adding lots of cells from different sheets

D

dodgyone

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

kk

Have you try =SUM('Sheet1:Sheet60'!F3)


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