Countif with criteria
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!
"Pete_UK" wrote:
See your other post for several replies.
You last statement seems to contradict what you ask for in the first
paragraph.
Pete
On Nov 12, 4:45 pm, 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.
|