Posted to microsoft.public.excel.worksheet.functions
|
|
COUNTIF across Multiple Rows and Columns
=COUNTIF(A1:E100,"W")
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
wrote in message
ups.com...
Hey guys...
What is an easy way to take:
COUNTIF(A1:A100,"W")
... And make it look at multiple rows and columns? In other words, I
have the following cells that "could" contain a "W", and I simply want
to "count" the ones that do:
A1, B3, C2, D5, E7
Thanks ahead for any help!!!
|