Alternatively you can try the below..Please note that this is an array
formula. Within the cell in edit mode (F2) paste this formula and press
Ctrl+Shift+Enter to apply this formula. If successful in 'Formula Bar' you
can notice the curly braces at both ends like "{=<formula}"


=AVERAGE(IF(($H$10:$H$89=0)*($N$10:$N$89=""),$AB$1 0:$AB$89))

'To take an average of entries in AB which are more than 0
=AVERAGE(IF(($H$10:$H$89=0)*($N$10:$N$89="")*($AB$ 10:$AB$890),$AB$10:$AB$89))


'To take an average of entris with W and AB0
=AVERAGE(IF(($H$10:$H$89=0)*($N$10:$N$89="W")*($AB $10:$AB$890),$AB$10:$AB$89))


'with SA,ST and W
=AVERAGE(IF(($H$10:$H$89=0)*($N$10:$N$89={"W","SA" ,"ST"})*($AB$10:$AB$890),$AB$10:$AB$89))

If this post helps click Yes
---------------
Jacob Skaria


"Romileyrunner1" wrote:

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!