Hi Domenic,

Thank you for clarification.

Cheers,
Sam

Domenic wrote:
I've just noticed (and replied to) your other post and realized that the
values for the columns you want evaluated differ from the ones in the
adjacent columns. So, if in fact you have no headers and are not
concerned with filtered data, the following formula should suffice...

=SUMPRODUCT(--(A1:J10="North"))

...which will count all cells in the range A1:J10 that contain the value
"North". Since Columns A, C, E, G, and I will never contain the value
"North", they won't be counted.

Hope this helps!

Hi Domenic,

[quoted text clipped - 8 lines]
Cheers
Sam


--
Message posted via http://www.officekb.com