If you are actually using the SUBTOTAL calculations in C111, C214, C327, etc
(note, you actually have the first 2 references 103 apart 111 to 214, not 113
apart as stated and shown by 214 to 327), then you can still use SUBTOTAL:

i.e.: values in C11-C110 are to be 'added' up in C111
C111: =SUBTOTAL(9,C11:C110)
values C114-C213 are to be added up in C214
C214: =SUBTOTAL(9,C114:C213)
C327: =SUBTOTAL(9,C227:C326)
....etc.
C25565: =SUBTOTAL(9,C25465:C25564)

Then your formula in C5 could be
=SUBTOTAL(9,C11:C25565)
Note: You may want to read up on the SUBTOTAL function, the first parameter
is how you want to add it up, 9 means SUM.

Hope this helps.
--
John C


"stew" wrote:

Hi
A simple one for you all

Total In C5

Made up of Sub Totals in C111,C214,C327 etc, always 113 apart to a final
location of C25655
Can you give the smart Formula that allows me to add these subtotals

Thanks for looking

Stew