Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totals and #Value!
I think this ia a very straightforward question.
I have a column of the number of items sold, each month a new column is added. at the bottom of each column is a grand total for the month in the form of =D14:D36 however if there are no items sold during the month then it returns #VALUE! If there are no sales then I would like it to show either 0 or just an empty cell. How can i achieve this please. Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totals and #Value!
You sure you didn't use:
=sum(d14:d36) or =subtotal(9,d14:d36) If you did, I'd look for cells that contain that error--maybe on a hidden row (do you have an autofilter applied?). If this doesn't help, you may want to repost your correct formula. Box666 wrote: I think this ia a very straightforward question. I have a column of the number of items sold, each month a new column is added. at the bottom of each column is a grand total for the month in the form of =D14:D36 however if there are no items sold during the month then it returns #VALUE! If there are no sales then I would like it to show either 0 or just an empty cell. How can i achieve this please. Bob -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totals and #Value!
=D14:D36
is not a valid formula, so I don't think this is really what you are using. You could have =SUM(D14:D36) but then this should return 0 if there's nothing in D14:D36. For further help, please post back with exact details. "Box666" wrote in message ... I think this ia a very straightforward question. I have a column of the number of items sold, each month a new column is added. at the bottom of each column is a grand total for the month in the form of =D14:D36 however if there are no items sold during the month then it returns #VALUE! If there are no sales then I would like it to show either 0 or just an empty cell. How can i achieve this please. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
How do I sum YTD totals based on monthly totals | Excel Discussion (Misc queries) | |||
totals | Excel Discussion (Misc queries) | |||
(Sub)totals | New Users to Excel | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |