Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average
I have a spreadsheet and in one column I have results from time. I am trying
to average this column and if I choose just the cells that have results so far, I get the correct average, but in my formula if I take the ending cell down so I don't have to change the formula each time, I get an average based on all the empty cells which makes the answer incorrect. This is my formula: =AVERAGE(IF(AG6:AG11342<0,AG6:AG11342,"")) My worksheet is only down to AG838, but I need it expanded for more data entry, but my average is showing 24 and if I change the AG11342 to AG838, I get the correct average of 16. Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
average
Pammy,
Average is 'smart' enough to ignore empty cells so providing the formula you posted is array entered (CTRL+Shift+Enter) then it should give the correct answer for the larger range. If is doesn't then I suggest you check all of your numbers are really numbers and not text that look like numbers Mike "Pammy" wrote: I have a spreadsheet and in one column I have results from time. I am trying to average this column and if I choose just the cells that have results so far, I get the correct average, but in my formula if I take the ending cell down so I don't have to change the formula each time, I get an average based on all the empty cells which makes the answer incorrect. This is my formula: =AVERAGE(IF(AG6:AG11342<0,AG6:AG11342,"")) My worksheet is only down to AG838, but I need it expanded for more data entry, but my average is showing 24 and if I change the AG11342 to AG838, I get the correct average of 16. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions |