Forum Discussion
Solved
Subtract items from running total
I’m trying to create a spreadsheet that will easily show the dollar amount remaining as items are purchased from a set dollar amount.
I have 35 rows of items with a price associated to each item in...
Joe,
You can use a formula like this:
=SUMIF(C2:C13,"No",B2:B13)
To add only the item prices that have a purchase status of no.
Please find the attached file.
Joe,
You can use a formula like this:
=SUMIF(C2:C13,"No",B2:B13)
To add only the item prices that have a purchase status of no.
Please find the attached file.
This should be incorporated from page to page as you use it for your set of home books or a small business. Works but needs to be able to move some of that data out 3 months as being paid in the future. IMO