[Karen Day]

Hi there,

I have say 3 columns of data in an excel spread sheet.

Column A = Multiple Names
Column B = MO, VOL, FWD
Column C = Mr, Mrs, Ms, Miss

So
Column A Column B Column C
John Doe MO Mr
Mary Smith Vol Ms
Lucy Richardo Mo Mrs
William Shatner FWD Mr
John Smith MO Mr
etc

I want to count column C only counting MR if Column B has MO in it.

So in the above example I would end up with a count of 2.

Can anyone help me with this?

thanks heaps in advance for any assistance.

Regards
Karen

[shades]

Multi-condition count is accomplished with SUMPRODUCT

=SUMPRODUCT(($B$2:$B$100="MO")*($C$2:$C$100="MR"))

Notice that you cannot refer to the entire column, and all conditions must refer to the same length range.

[Karen Day]

Thank you so much - works perfectly
regards
Karen

[Tbug2]

Thanks from me, too. I couldn't figure out how to make countif work for this situation, either. Sometimes slow and old is better, take's one to know one!

[shades]

Glad that it helped.