CountIF for Data
 

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

CountIF for Data
 

=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

CountIF for Data
 

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
---
"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

CountIF for Data
 

There must be a better way to do this in a single step, but this will also
work ... in C1 enter:

=IF(AND((A1="Member",B1="Student"),True,False)

then use the countif function to count the number of TRUE values in C.




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

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

CountIF for Data
 

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

CountIF for Data
 

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