CountIF for Data

[Linda]

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

 

[Bernard Liengme]

=SUMPRODUCT(--(A1:A100="Member"),--(B1:B100="Student"))
For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html

best wishes

 

[Max]

Sumproduct springs to mind for multiple criteria counts, eg in C1:
=sumproduct((A1:A10="Member")*(B1:B10="Student"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[Teethless mama]

IF you use XL-2007 then try this:

=COUNTIFS(A:A,"Member",B:B,"Student")

 

[Shane Devenshire]

Hi,

Bernard and Max's formulas are effectively the same, however, Bernard's is
prepared to handle a few problems that the other one won't.

But if you just want short:

=SUMPRODUCT(N(A1:A5&B1:B5="MemberStudent"))

or if you enter Member in D1 and Student in D2

=SUMPRODUCT(N(A1:A5&B1:B5=D1&D2))

or you can use the array equivalent:

=SUM(N(A1:A5&B1:B5=D1&D2))

In this case press Shift+Ctrl+Enter to enter the formula rather than Enter.

 

[T. Valko]

Bernard and Max's formulas are effectively the same

Bernard's is prepared to handle a few problems that the other one won't.

Such as?