Forum Discussion
Joe Sixpack
Feb 07, 2018Copper Contributor
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...
- Feb 07, 2018
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.
Haytham Amairah
Feb 07, 2018Silver Contributor
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.
Mike Tucker
Feb 08, 2018Copper Contributor
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