Average Problem
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!!!! |
Average Problem
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! In article , 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!!!! |
Average Problem
=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!!!! |
Average Problem
Thank you so much, i can go out for a beer tonight now
"Domenic" wrote: 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! In article , 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!!!! |
All times are GMT +1. The time now is 02:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com