How do I count one cell based on another cell?

G

Guest

How do you count the number of cells with data (not blank) in a given range
based on a criteria in a different range? for example, how many corresponding
cells are populated with data in c1:c1000, if b1:b1000 = SMU? I have tried so
many variations of the the following to no avail.
=COUNT(IF(b1:b1000,"SMU",counta(c1:c1000)))
If anyone can resuce me...I am frustrated...what am I missing?
Harr
 

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

Why doesn't excel count function update automatically? 1
count if (possibly?!) 6
Locking a cell based on a cells content 1
change a formula based on another cell value 3
Match, then autopopulate, based on condition 3
How To Have A Cell Be Blank If... 2
cell refrence based on specific criteria 3
How can my formula handle inserted rows? 3

Top