Hello Jeff

Apologies for the delay.

What is want is for the cells in column F to display a sub total, in line with where cells in column C display "Consecutive End". So in the case of the result in F5 in my attachment I tried to formulate:

F5 = the sum of (B3 x E3) + (B4 x E4) + (B5 x E5).

F5 shows the subtotal because C5 displays "Consecutive End". I need this to loop through the rest of the table.

I hope this makes more sense of my nonsense, and I am open to better ways to calculate this from you.

Many thanks
G1