|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 7th, 2009, 08:35 PM
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
November 7th, 2009, 09:02 PM
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
November 7th, 2009, 10:14 PM
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
November 7th, 2009, 10:42 PM
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
November 8th, 2009, 05:23 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
