Hi

if you want to count entries in a cell then use a formula similar to
=COUNT(Jan:Dec!A1)
where Jan is the name of the first sheet and Dec is the name of the last and
the sheets you want to include are between these two

if you want to total the cells try
=SUM(Jan:Dec!A1)

you might also like to check out data / consolidation for this as well.

Cheers
JulieD

"Fybo" wrote in message
...
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.