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