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?