•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Subtracting a running total from individual cells based on other cells populated
Our take
Managing running totals in Excel can be streamlined for efficiency, especially when accounting for disposal site names and their associated container counts. To subtract totals dynamically as the 'Date Out' is filled, consider using a formula that references both the disposal site and the remaining containers. This approach not only simplifies calculations but also enhances usability for colleagues. By ensuring your formulas are clear and efficient, you can minimize workload and improve productivity across your team.
(Excel 365 v2604)
I feel like I'm over thinking this entire situation. I Googled to figure out how to get the totals of containers based on the disposal site names with:
=IFERROR(SUM(VALUE(TEXTSPLIT(TEXTJOIN("/",TRUE,IF(E4:E100="CE",C4:C100,"")),"/"))), 0) | Container Count (C) | Disposal (E) | Date Out (H) | Company | Total |
|---|---|---|---|---|
| 11 | CE | 4.30.26 | CE | 19 |
| 1/2 | CE | 4.30.26 | D&L | 3 |
| 2 | CE | 4.30.26 | E | 2 |
| 2/1 | CE | 4.30.26 | 24 |
I have the same code in each total for each company but I'm racking my brain trying to figure out how to live subtract as the 'date out' gets filled meaning I'd have a separate cell updated with the number 5 since there would be 5 total left from the other sites
If there's a cleaner way to do this, please point me to that direction. I am trying to make this workbook as efficient as possible for other employees to minimize the amount of work needed.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#financial modeling with spreadsheets#no-code spreadsheet solutions#Excel alternatives#rows.com#cloud-based spreadsheet applications#Excel 365#running total#container count#IFERROR#disposal#date out#company total#SUM#formula#VALUE#TEXTSPLIT