1 min readfrom 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!

submitted by /u/Deathandblackmetal
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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