Average Problem

P

Paul

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:D444)) 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!!!!
 
D

Domenic

Do you mean Column D contains blanks? If so, try...

=AVERAGE(IF(Data!$E$2:$E$444="OG",IF(Data!D2:D444<>"",Data!D2:D444)))

....confirmed with CONTROL+SHIFT+ENTER. Adjust the ranges, if necessary.

Hope this helps!
 
T

Teethless mama

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

ctrl+shift+enter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate last 4 data points in a column (with sometimes blank rows) 7
Remove punctuation mark, Split cells & average accross column 4
Average formula works but.... 5
Average formula only works partially..... 6
Help requested for nested conditional formulas referencing other c 3
Sumproduct in matrix means 3
Average with #DIV/0! 4
calculate average from non contiguous column, ignoring (0) values 3

Top