adding lots of cells from different sheets

[Guest]

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?

 

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

 

[Domenic]

Try...

=SUM('Sheet1:Sheet60'!F3)

Hope this helps!