Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need help with running totals | Excel Worksheet Functions | |||
Running Totals | Excel Discussion (Misc queries) | |||
Running Totals | Excel Worksheet Functions | |||
Running Totals | New Users to Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |