how to average a range of cells and ignore #div/0! answer

V

Vince

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
 
F

FSt1

hi
=IF(A2=0,"",AVERAGE(A2:A10))
or
=IF(A2=0,0,AVERAGE(A2:A10))

adjust range to suit.

Regards
FSt1
 
T

T. Valko

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),"")
 
T

T. Valko

mark

--
Biff
Microsoft Excel MVP


T. Valko said:
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),"")
Click to expand...
 
F

FSt1

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
 

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

How do I average a group of cells and ignore a #div/0! error? 8
#DIV/0! error 1
#div/0 error 2
Find Average w/ #DIV/0! in Cell 5
Need "Div/0" Average Relief ... 4
average range of cells with zero and blanks 3
#DIV/0 error 2
How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0") 5

Top