| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
adding lots of cells from different sheets
I am trying to add up all the totals from seperate supplier vat sheets they
are all of the same layout I tried =SUM('Sheet1'!F3,'Sheet2'!F3......Etc.) It keeps saying formula is too big, i want to add up about 60 separate sheets is there any way i can do this? |
|
#2
|
|||
|
|||
|
Have you try =SUM('Sheet1:Sheet60'!F3)
"dodgyone" wrote in message ... I am trying to add up all the totals from seperate supplier vat sheets they are all of the same layout I tried =SUM('Sheet1'!F3,'Sheet2'!F3......Etc.) It keeps saying formula is too big, i want to add up about 60 separate sheets is there any way i can do this? |
|
#3
|
|||
|
|||
|
Try...
=SUM('Sheet1:Sheet60'!F3) Hope this helps! In article , "dodgyone" wrote: I am trying to add up all the totals from seperate supplier vat sheets they are all of the same layout I tried =SUM('Sheet1'!F3,'Sheet2'!F3......Etc.) It keeps saying formula is too big, i want to add up about 60 separate sheets is there any way i can do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
| adding summed cells in a conditional sumif | Excel Worksheet Functions | |||
| Adding separate accumulators for multiple cells | New Users to Excel | |||
| when adding cells resulting from tax calulations they do not equa. | Excel Discussion (Misc queries) | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Hybrid Mode
