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 -