How to select blank cells only whilst using sumproduct

[Romileyrunner1]

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!

 

[Jacob Skaria]

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$10:$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$89>0),$AB$10:$AB$89))


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


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

If this post helps click Yes