resolve undefined in running totals when data not input


A

Aso

Thanks in advance, any help is appreciated.

I am working on an excel spreadsheet that is a table with calculated running
totals of certain data etc. Say there are going to be responses for each
month of the year but having only completed the 3rd month, the calculations
for the other months show up as undefined because it is attempting to divide
by zero due to no data. I need teh running total to continue adding on when
new data is entered but i am not sure how to go about eliminating the
undefined (#Divo/0!) until data has been input so that the other months will
total correctly. This probably sounds extremely simple to some of you out
there but i am stumped. ANY help is appreciate =) thank you

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total / Average
8 8 #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0!
8 16 #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0!



Aso
 
Ad

Advertisements

A

Aso

Ack sorry that wrapped around.. let me make an adjustment...

Jan Feb Mar Apr May ... Total /
Average
8 8 #Divo/0! #Divo/0! #Divo/0!
Running ToT: 8 16 #Divo/0! #Divo/0! #Divo/0!... #Divo/0!
 
Ad

Advertisements

G

Gord Dibben

The usual practice is to trap for the lack of data and return "" instead of
the error.

Example =IF(A1="","",B1/A1)

You could also use the ISERROR in earlier versions or IFERROR in 2007
function but I do not recommend that because it will mask all errors which
may not be desirable.


Gord Dibben MS Excel MVP
 

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

Top