Summing every three values in row

Hi Sambridge and welcome to the forum,

I see a lot of these kinds of problems where people create a table to save time in typing. If you create a better table (more typing sometimes) the problem gets easy. Look at my new sheet, where I've created a different structure table and then a Pivot Table to display the data you want. I didn't need any formulas to arrive at my Pivot Table answer. See if this type on structure will work for you.

I would go with Marvin's suggestion first but if you are stuck with what you have.

Assuming we are going out to Column AM
For Standard
=SUMPRODUCT(--(ISNUMBER($D$8:$AM$8)), --($D$8:$AM$8<($D$4+31)),$D$10:$AM$10)

For Time and a half
=SUMPRODUCT(--(ISNUMBER($D$8:$AM$8)), --($D$8:$AM$8<($D$4+31)),$E$10:$AN$10)
notice, the columns to sum are moved one to the right ("E10:AN10)

and for double time (same idea)
=SUMPRODUCT(--(ISNUMBER($D$8:$AM$8)), --($D$8:$AM$8<($D$4+31)),$F$10:$AO$10)

My Custom Function Seems to work:

I have called it StepSum. It is designed to sum the cells in a range but with the inclusion of a step.

so

Please Login or Register  to view this content.

will count every third cell horizontally

I wrote it to work vertically to

so

Please Login or Register  to view this content.

should count every third cell vertically

And

Please Login or Register  to view this content.

Sould work horizontally and vertically.

Please Login or Register  to view this content.