Sum Column Untill Criteria is met AND Repeat Formula

[Johnhtvu]

Hi everyone - I have been trying all day but I can't seem to find a way to make my formula repeat after a criteria is met. Please see screenshot.

Situation:
I have a table. in column [Cogs Value] you see prices of ingredients that I want to sum. in column [subrecipe name] you can enter any text and the row will turn yellow to indicate a new recipe. in column [subrecipe cost] I want to sum the cost of all ingredients that belong to that recipe.

Problem:
What formula can I use in the [subrecipe cost] column? The formula should be able to:
1 stop summing once any value in column [subrecipe name] is made
2 Start the formula again to sum up for the new recipe

Potential solution/ ideas:
I was thinking to somehow use the formulas:
- Sumifs (with criteria that column [subrecipe name] contains any text.
- What other formula to add so I can repeat the formula once that criteria is met?

Help is much appreciated!
Thank you everyone (sorry if I did not explain it clearly)

 

[jasonb75]

We are not able to test formula on screen captures, but I think that this should work. Enter the formula into E8, then fill down.

=IF(C8="","",SUM(J9:J$26)-SUM(E9:E$26))

As we don't know which columns the relevant items of data are located in, I've assumed C, E and J by counting the visible columns and assuming that none are merged.

 

[Johnhtvu]

We are not able to test formula on screen captures, but I think that this should work. Enter the formula into E8, then fill down.

=IF(C8="","",SUM(J9:J$26)-SUM(E9:E$26))

As we don't know which columns the relevant items of data are located in, I've assumed C, E and J by counting the visible columns and assuming that none are merged.

Hi Jason

This worked!! Thank you for taking the time to reply to my question. I appreciate it!

John