I have a spreadsheet where the hours of wear for pieces of equipment are logged:
- Data is logged in new rows as additional wear-hours are put on the equipment.
- From time to time, equipment is replaced, and a text entry "reset" is added to the column and logging of the replacement continues below that entry.
- This may be repeated several times, and hours logged for equipment that was replaced is never removed.
How can I add the total hours logged in a column while excluding any entries that precede the very last instance of "reset"?
What formula would I put in
B1 that would add
B2:B3 is followed by a "RESET" in