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?

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?

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?