Countif with criteria

[NM]

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.

 

[Peo Sjoblom]

Please do not multipost, you have already received multiple answers to your
first post

--


Regards,


Peo Sjoblom

 

[Pete_UK]

See your other post for several replies.

You last statement seems to contradict what you ask for in the first
paragraph.

Pete

 

[Shane Devenshire]

Hi,

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

Cheers,
Shane Devenshire

 

[Pete_UK]

Shane,

you can only do this with XL2007 - for earlier versions you can't have
full-column references with SP.

Pete

 

[NM]

Hi,

I did not see my first message posted ofr a long time , so I thought that
the message did not got posted. Hence I reposted it.
I apologise fo r the inconvenience.

Thanks!

 

[NM]

I'm sorry the last statement is a typo!It should read I do not want to count
the "I" in column c if column B has 0 or sh.

Thanks!

 

[NM]

Hi,

I am getting a #value error!

Can you please help me.
Thanks!

 

[NM]

I could fix the #value Error but the formula is giving me wrong answer!

 

[NM]

Hi,

I still cannot see where is my first post and the answers to it! I am still
looking for an answer to my question.
How can I locate my first post? search doesn't help me.

Thanks!

 

[Pete_UK]

Here's a link to your other post:

http://groups.google.com/group/micr....functions/browse_frm/thread/d3c72a17df3410aa

Hope this helps.

Pete

 

[Ashish Mathur]

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com