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
|
|||
|
|||
#DIV/0! instead of total
I have a worksheet I am adding the numbers to daily for
calculations. Rather than showing the correct amount at the column on the end which averages the numbers I add daily, it only shows #DIV/0!. The number does work when every day of the month is filled out. It also shows this in places where it is awaiting numbers to finish the calculation. How do I rememdy this? Thanks! Melinda |
#2
|
|||
|
|||
#DIV/0! instead of total
Hi
you may post the formula which results in this #DIV/0 error a general way to prevent this is =IF(N(A1)=0,"",B1/A1) -- Regards Frank Kabel Frankfurt, Germany Melinda wrote: I have a worksheet I am adding the numbers to daily for calculations. Rather than showing the correct amount at the column on the end which averages the numbers I add daily, it only shows #DIV/0!. The number does work when every day of the month is filled out. It also shows this in places where it is awaiting numbers to finish the calculation. How do I rememdy this? Thanks! Melinda |
#3
|
|||
|
|||
#DIV/0! instead of total
Without your posting your formulae, it's hard to make a specific
suggestion, but in general, if your formula now is =A1/B1 you should use something like =IF(B1=0,"",A1/B1) Your Average cell may be passing along the #DIV/0 errors, or may have a division by zero itself if there are no numeric entries in the range. Note that Average ignores text values. In article , "Melinda" wrote: I have a worksheet I am adding the numbers to daily for calculations. Rather than showing the correct amount at the column on the end which averages the numbers I add daily, it only shows #DIV/0!. The number does work when every day of the month is filled out. It also shows this in places where it is awaiting numbers to finish the calculation. How do I rememdy this? Thanks! Melinda |
#4
|
|||
|
|||
#DIV/0! instead of total
You can change the formulas that return the div error, i.e.
=IF(C3=0,"",A3/C3) or you can use =SUMIF(D5100,"#DIV/0!") which says sum everything except div errors while any other formula will return the error instead of the total. You might want to go with option 1 though and make sure you don't get any errors and then use a regular sum =SUM(D5100) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Melinda" wrote in message ... I have a worksheet I am adding the numbers to daily for calculations. Rather than showing the correct amount at the column on the end which averages the numbers I add daily, it only shows #DIV/0!. The number does work when every day of the month is filled out. It also shows this in places where it is awaiting numbers to finish the calculation. How do I rememdy this? Thanks! Melinda |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Report showing current total, previous total and average total? | Richard Black | Setting Up & Running Reports | 3 | July 20th, 2004 01:22 PM |
Total number of pages in mail merge document per document | Ava Healy | Mailmerge | 1 | May 27th, 2004 06:50 AM |
adding total cost from a month | Andrew | Worksheet Functions | 4 | May 17th, 2004 02:36 PM |
Large clothing orders | annas3 | Worksheet Functions | 7 | January 27th, 2004 04:23 PM |