Count occurences in columns, with criteria?
Posted by Al on December 07, 2000 9:22 AM
This is probably a very simple one for you, certainly compared to others on the Board.
I have two columns, Gender and Age. The Gender column contains either the word "male" or "female". The Age Group Column has either a "1", "2" or "3". I need a formula to count say, how many males are in age group 3. Sounds simple but I'm unfamilar with Excel.
I'd appreciate any help you can give.