COUNTIF across Multiple Rows and Columns
 

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!!!

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!!!