View Single Post
  #1   Report Post  
Fybo
 
Posts: n/a
Default COUNT over several sheets

Hi,

I am compiling an annual report with 12 sheets (one per month) and a final
13th summary sheet.

Each of the 12 monthly sheets are identical and I want to add the totals for
each month and present it as an annual figure on the final sheet (sheet #13).

I cannot figure out how to get Excel to look at all my sheets and total
these on the final.

Can it be done? Can anyone help!!

Many thanks,

Fybo.