Count with criteria

[NM]

Hi,

I have a column B which can have input as 1, 0,a or sh. Another Column C can
have input as I,D,X,M. I want to count the number of "I"s in column C which
have "1" in column B. In other words if column B has o ans column c has I , I
do not want to count it.

Column B Column C
1 I
0 I
sh D

Thanks for your help.

[John C]

A1: 1
A2: I
=SUMPRODUCT(--($B$2:$B$100=A1),--($C$2:C$100=A2))
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.

[Sheeloo 95 64]

Try this in A1 (or anywhere other than B1:C100)

=SUMPRODUCT(--(B1:B100=1),--(C1:C100="I"))

Adjust 100 to the last row in your data set.

[Pete_UK]

Try this:

=SUMIF(C:C,"I",B:B)

Hope this helps.

Pete

[Mike H]

Try this

=SUMPRODUCT((B1:B30=1)*(C1:C30="I"))

Mike

[NM]

Thanks much! It works!