Herostrata
New Member
 Joined
 May 14, 2021
 Messages
 4
 Office Version

 365
 Platform

 Windows
Hi All,
Long time reader, first time poster.
I'm looking for a formula that will give me the sum for a range of cells since the last time that range was summed. Let me explain:
I have a variable list being output. Column A will be a list of items, Column B is the numerical value. Occasionally column A will read "Total" and when it does I want column C to give a sum of column A between the "Total" values. e.g.:
I'm simplifying heavily and I think there's something I can do with an INDEX / MATCH combination but can't quite get it to work.
Thanks in advance.
Long time reader, first time poster.
I'm looking for a formula that will give me the sum for a range of cells since the last time that range was summed. Let me explain:
I have a variable list being output. Column A will be a list of items, Column B is the numerical value. Occasionally column A will read "Total" and when it does I want column C to give a sum of column A between the "Total" values. e.g.:
A  B  C 
Rent  600  
Car  300  
Food  150  
Total  1050  
Rent  600  
Food  200  
Total  800  
Car  450  
Food  100  
Total  550  
Food  150  
Total  150 
I'm simplifying heavily and I think there's something I can do with an INDEX / MATCH combination but can't quite get it to work.
Thanks in advance.