One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=AVERAGE(IF((A3:A45="Photo")*(H3:H45<""),H3:H45))
In article ,
"Spottkitty" wrote:
=AVERAGE(IF($A$3:$A$45="Photo",H3:H45))
This is the array I'm using to try to determine an average. Problem...if
the field is blank it's counting it as zero and lowering the results. It
figured 79% when it should have been 94%. 94% was returned using the simple
average formula. I'm guessing I need to nest something to not count nulls?
Help!!!
|