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

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

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