How can I calculate Several Cell adding Formulas?

I'm trying to add several cells together to get a total. This includes cells
in another worksheet, but if I plug them in one by one, it says the Formula
is too long, is there anyway to shorten the formula?

Originally Posted by David Marinez

I'm trying to add several cells together to get a total. This includes cells
in another worksheet, but if I plug them in one by one, it says the Formula
is too long, is there anyway to shorten the formula?

There are probably several ways.

One way might be to have one cell on the other worksheet that totals the cells on that worksheet that you need, and then just reference it.

Scott

a sample perhaps?

--
Don Guillett
SalesAid Software
[email protected]
"David Marinez" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to add several cells together to get a total. This includes
> cells
> in another worksheet, but if I plug them in one by one, it says the
> Formula
> is too long, is there anyway to shorten the formula?