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