You might want to reformat the sheet using the subtotal() function
check help for details
The subtotals would thewn truely be sutotals and the master total would not
count the subtotals shown
in other words if C14 is =subtotal(9,C6:C13)
and C23 =subtotal(9,C15:C22)
etc
and in c68 you wanted a true total
=subtotal(9,C6:C67) would be the total ignoring all of the subtotal in the
range.

in other words your final equation might be something like
=subtotal(9,C6:C67,G6:G67,K6:K67,O6:O67)
as long as all of the current subtotals were made using subtotal()

"ab" wrote:

Excel 2003 - hope this is the right group to ask.

I am trying to find a formula for a time sheet for employees. I will try to
show an example:

Col A (job number) Col B hours in day
2103x 4.0
2402 2.0
1234 2.0
___
sub-total 8.0

This continues in four blocks for each working day of the month. At the end
of block 4, I need a total of all the sub-totals. The person who set up the
sheet just had:
=SUM(C14+C23+C32+C41+C50+C59+C67+C75+G14+G23+ G32+G41+G50+ G59+G67+G75+
K14+K23+K32+K41+K50+K59+K67+K75+ O14+O23+O32+O41+O50+O59+O67 etc, but I'm
sure there must be an easier way!!

I would really appreciate some advice - I have tried using Help but don't
really know how to phrase the question!

TIA