Count problems

S

Sqdncall

I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance
 
S

Shane Devenshire

Hi,

In 2003 or 2007 you can also use this

=SUMPRODUCT(--(A1:A8&B1:B8="A"))
 

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

Help in counting and summing cells based on multiple conditions 9
Excel Countifs/Sumproduct with mutil Or statement 3
Sum total using Sumproduct if two criteria met 5
Count values in column only if value of another column is true 4
count nonblank cells 3
SUMIF with criteria "<>" & "=" 4
count if for blanks with 'or' 3
use month in cell date to sum all relevant cells 2

Top