•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
(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]
Want to read more?
Check out the full article on the original site
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