Hi, well stuck and I`m sure it`s simple but have tried everything: I think!
Using the following very successfully BUT... Now I want the second and the
last array to become (SN$10:$N$89= "Blank cells only") : the rest to stay the
same.

=SUMPRODUCT(($H$10:$H$89=0)*($N$10:$N$89="W"),($AB $10:$AB$89))/SUMPRODUCT(($H$10:$H$89=0)*($N$10:$N$89="W"))

I`ve tried
<""
<"*"
=""

Any suggestions?????

If that can be sorted, and I`m sure it can, How would I also ask to pick out
more than 1 specific texts from that array e.g.
(SN$10:$N$89= "W" or "SA" or "ST" )

In eager anticipation .... I need some sleep HELP!