Counting non blanks with SUMPRODUCT?

[Mifty]

Hi everyone is there a way to add another bit to get this formula to only
count if cells in column A are blank?

=SUMPRODUCT((All!$C$2:$C$1205=$A8)*(All!$W$2:$W$1205<=$Q$2))

Hoping someone can help

Cheers

 

[Pete_UK]

Try something like this:

=SUMPRODUCT((All!$C$2:$C$1205=$A8)*(All!$W$2:$W$1205<=$Q$2)*(All!$A$2:$A$1205=""))

Hope this helps.

Pete

 

[Mike H]

Maybe:-

=SUMPRODUCT((All!$C$2:$C$1205=$A8)*(All!$A$2:$A$1205="")*(All!$W$2:$W$1205<=$Q$2))

Mike

 

[Mifty]

Thank you both !!!!
--
Mifty

Try something like this:

=SUMPRODUCT((All!$C$2:$C$1205=$A8)*(All!$W$2:$W$1205<=$Q$2)*(All!$A$2:$A$1205=""))

Hope this helps.

Pete

 

[Pete_UK]

Both ??!!

You're welcome.

Pete

Thank you both !!!!
--
Mifty





- Show quoted text -