•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sum of dollar totals (ignoring text) in a column?
Howdy all, I am quite beginner with Excel formulas and I cannot figure this out. I've tried looking online and on here; using things like =sum, =sumif, =count, to no avail.
Basically, I track my pay versus whatever bills are due during that specific period to see how much money is remaining once the bill amounts are all accounted for.
Here's a quick little pseudo example I just made up.
Green is paycheck. Red is the value of the bills above it totaled together. Blue is paycheck minus red value, so I can get a quick idea of how much funding I have left. I've been adding these up manually for... way too long, hah. Thank you!
[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
#rows.com
#Excel alternatives
#financial modeling with spreadsheets
#Excel
#formulas
#bills
#sum
#paycheck
#dollar totals
#sumif
#money
#tracking
#count
#funding
#remaining
#manual