Hi,

=sumoroduct((rangeB=1)*(rangeC="I"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"NM" wrote in message
...
I could fix the #value Error but the formula is giving me wrong answer!

"NM" wrote:

Hi,

I am getting a #value error!

Can you please help me.
Thanks!

"Shane Devenshire" wrote:

Hi,

=SUMPRODUCT(--(B:B=1),--(C:C="I"))

Cheers,
Shane Devenshire

"NM" wrote:

Hi, I have column B which can have a,0,1,sh as its input. I have
another
column c which can have I,X,D,M as its input. I want to count all the
"I" in
column c only if Column B=1.

I do not want to count the "I" in column c if column B has 0,1 or sh.

Thanks for you help.