Counting non blanks with SUMPRODUCT?
 

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$12 05<=$Q$2))

Hoping someone can help :-)

Cheers
--
Mifty

Counting non blanks with SUMPRODUCT?
 

Try something like this:

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

Hope this helps.

Pete

"Mifty" wrote in message
...
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$12 05<=$Q$2))

Hoping someone can help :-)

Cheers
--
Mifty

Counting non blanks with SUMPRODUCT?
 

Maybe:-

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

Mike

"Mifty" wrote:

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$12 05<=$Q$2))

Hoping someone can help :-)

Cheers
--
Mifty

Counting non blanks with SUMPRODUCT?
 

Thank you both !!!!
--
Mifty


"Pete_UK" wrote:

Try something like this:

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

Hope this helps.

Pete

"Mifty" wrote in message
...
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$12 05<=$Q$2))

Hoping someone can help :-)

Cheers
--
Mifty

Counting non blanks with SUMPRODUCT?
 

Both ??!!

You're welcome.

Pete

On Feb 7, 12:04*pm, Mifty wrote:
Thank you both !!!!
--
Mifty



"Pete_UK" wrote:
Try something like this:

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

Hope this helps.

Pete

"Mifty" wrote in message
...
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$12 05<=$Q$2))

Hoping someone can help :-)

Cheers
--
Mifty- Hide quoted text -

- Show quoted text -