-2

I have a Google Sheets doc that I use to track my monthly bills. In one column I have the amount that is owed each payday. As a bill gets paid, in another column next to it I place an X, this was I know it has been paid.

I want a formula that will calculate the sum of all bills left to be paid.

Improve this question

1 Answer 1

Reset to default
0 
Column A   "Bill" 5 7 11
column B   "Paid" x    x

in the total cell

=sumif(B2:B4,"X",A2:A4)

Sumif syntax

Improve this answer
1
  • Awesome Thanks! I thought it might be a SUMIF formula, but couldn't figure it out!
    – John Gawler
    Commented Feb 22, 2022 at 2:23

Not the answer you're looking for? Browse other questions tagged or ask your own question.