Subtotal based on Cell condition

Hello All

I have a spreadsheet where column B contains the number of products, C contains the words "consecutive" and "consecutive end" and column E contains the amount. I have attached a mock up for clarity.

What I would like is a formula (or VB) to add a subtotal in column F, so that the formula is totalling up until (and including) it reaches the cell called "consecutive end", then I want the formula to calculate the next subtotal. Hopefully the attached will make more sense.

Any help much appreciated.

Many thanks
G1

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

Thank you TMS, I will give that a try as I think you are right; I need to remember that Excel is a program and not capable of thinking like a human, so the code to do this would indeed be messy.

Thanks again
G1

Thank you TMS, I will give that a try as I think you are right; I need to remember that Excel is a program and not capable of thinking like a human, so the code to do this would indeed be messy.

Thanks again
G1