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?

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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