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))
 
Back
Top