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.