CountIF for Data
IF you use XL-2007 then try this:
=COUNTIFS(A:A,"Member",B:B,"Student")
"Linda" wrote:
I would like to count the number of occurances of "Student" only if "Member"
is true. Is COUNT the correct function?
A B
1 Member Student
2 Member Senior
3 Member Student
4 Fundraiser Student
5 Fundraiser Senior
|