Count with criteria
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.
"NM" wrote:
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.
|