Autosum

[Toddy59]

Hi again Experts

Is there a way to look along a row, find the first cell that has a number in it, if so autosum that cell and the next 3 cells (4 in total).

Then I would like to look along the row again, ignore the first 4 populated cells, autosummed before, and autosum the next 4 cells.

Placing the two results at the end of the row of data.

Thank you so much for all your help
Kathryn

 

[PaddyD]

"and the next 3 cells..."

Are the next 3 cells contiguous with the first or moght there be gaps?

 

[Toddy59]

Hi there

there are no gaps....

Thank you for the quick response

Kathryn