Counting Values across multiple sheets

Trust you to think of that, Biff !!

Nice one.

Pete

Hi Tony
thanks for your suggestion but you'll have to forgive my inexperience please and just give some pointers as to what certain things refer to in your formula, namely:

1. 41548
2. {0,7,14,21,28,35,42,49,56,63,70,77}
3. mmmd

Thanks for your understanding
Chris

Hi Chris,

Tony won't be on-line for a few hours so I hope he doesn't mind if I answer for him:

1. The number 41548 is the serial number that represents the date of 1st October 2013 (put that number in a cell somewhere and format the cell as a date).

2. Those numbers (increments of 7) are added onto that start date to get other dates which are a week apart.

3. The string "mmmd" is a format string used in conjunction with the TEXT command - it converts those dates into the format OCT1, or OCT7, or OCT14 etc. to match the names of your sheets.

The formula takes each sheet name in turn and uses it within the COUNTIF function.

Hope this helps.

Pete