View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 299
Default 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!!!