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
Bookmarks