COUNTIF across Multiple Rows and Columns

S

stacy.mcmillan

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count rows based on multiple criteria 3
Count values in column only if value of another column is true 4
COUNTIF Multiple Values 3
COUNTIF function across more than 1 column 0
COUNTIF - Multiple Criteria 6
3d countif 8
Counting on two separate values 5
COUNTIF not including something in both columns 2

Top