I'm trying to calculate the number of itmes in one Cell that also has a specific values in another Cell.
Example: I have a column for Job Type, F. Name, L. Name, and Age. I want to create a formula that displays the number of times a particular Job Type and F. Name displays in the columns.
I've attached a sample spreadsheet. In it I've listed in Cells F3 - F6 what I'm trying to accomplish and in Cels G3 - G6 were my attemps (most failed), I was able to use the CountIF formula to calculate the first one (F3/G3) but, the others are not as easy because they require two values be specific.
As always, thanks in advance for your help