View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] stacy.mcmillan@comcast.net is offline
external usenet poster
 
Posts: 5
Default 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!!!