=AVERAGEA(IF((Data!$E$2:$E$4444="OG")*(Data!$E$2:$ E$4444<""),Data!D2:D444))

ctrl+shift+enter

"Paul" wrote:

I'm trying to Average cells in a column that match a criteria in another
column and the column includes blanks. The problem i'm having is the formula
is returning results average for the whole column and not the cell i want to
match. Formula i'm using as follows.
=AVERAGEA(IF(Data!$E$2:$E$4444="OG"<0,Data!D2:D44 4)) This is returning an
average for the whole column and not just "OG". The formula works if i take
out the <0 but then the average includes the blank cells. HELP!!!!