| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to average a range of cells and ignore #div/0! answer
How do I average a range of cells that are blank until data is entered later
with out the destination cell returning a #div/o! error |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to average a range of cells and ignore #div/0! answer
hi
=IF(A2=0,"",AVERAGE(A2:A10)) or =IF(A2=0,0,AVERAGE(A2:A10)) adjust range to suit. Regards FSt1 "Vince" wrote: How do I average a range of cells that are blank until data is entered later with out the destination cell returning a #div/o! error |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to average a range of cells and ignore #div/0! answer
Try something like this...
The formula won't calculate an average until at least 1 number is entered in the range. =IF(COUNT(A1:A10),AVERAGE(A1:A10),"") -- Biff Microsoft Excel MVP "Vince" wrote: How do I average a range of cells that are blank until data is entered later with out the destination cell returning a #div/o! error |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to average a range of cells and ignore #div/0! answer
mark
-- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try something like this... The formula won't calculate an average until at least 1 number is entered in the range. =IF(COUNT(A1:A10),AVERAGE(A1:A10),"") -- Biff Microsoft Excel MVP "Vince" wrote: How do I average a range of cells that are blank until data is entered later with out the destination cell returning a #div/o! error |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to average a range of cells and ignore #div/0! answer
good call. i didn't think that out far enough. i assumed that the first cell
in the range would be the first to have data. thanks for a better insight. regards FSt1 "T. Valko" wrote: Try something like this... The formula won't calculate an average until at least 1 number is entered in the range. =IF(COUNT(A1:A10),AVERAGE(A1:A10),"") -- Biff Microsoft Excel MVP "Vince" wrote: How do I average a range of cells that are blank until data is entered later with out the destination cell returning a #div/o! error |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to average data if in cells, but ignore blank cells. | Excel Worksheet Functions | |||
| How do I average a group of cells and ignore a #div/0! error? | Excel Discussion (Misc queries) | |||
| creating a popup answer for an average range of cells | Excel Worksheet Functions | |||
| How do I ignore cells with errors when calculating an average? | Excel Worksheet Functions | |||
| Blank cells in named range- how to ignore them when making my graph? Help plz! | Excel Discussion (Misc queries) | |||
Linear Mode
