Help with Count(If(.....

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

sowetoddid

This is my equation.

=COUNT(IF('Houston Office'!$D$64:$D$83=1,'Houston Office'!$C$64:$C$83)
-- ARRAY



If a cell in column D has a 1, then I want to count the associated cel
in column C. However, if that cell in column C does not have a value
then it should not be counted.

With the equation above, C is counted even though it is empty...


Any ideas?
 
One way

=SUMPRODUCT(--('Houston Office'!$C$64:$C$83<>""),--('Houston
Office'!$D$64:$D$83=1))
 

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

Match & array 2
excel count problem 1
Count with criteria 5
calculation problem 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
CountIf with And 0
How to count last number 7
use month in cell date to sum all relevant cells 2

Back
Top