| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I calculate Several Cell adding Formulas?
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I calculate Several Cell adding Formulas?
David Marinez Wrote: 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 -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=563343 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Hybrid Mode
