How can I calculate Several Cell adding Formulas?

D

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?
 
M

Maistrye

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

There are probably several ways.

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


Scot
 
Top