Try this:

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

Hope this helps.

Pete

On Nov 12, 4:21*pm, 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.