Formula needed

amy16451

Happy Thursday, all!  

I have a sheet with invoice dollar amounts in several cells.('Amount')

Next to these cells, I have a checkbox column called 'Paid' that is checked on if the invoice was paid, checked off if the invoice was not paid.

I need to total all invoice amount cells for invoices that are paid.

Any tips on the formula that should be used for to complete this?  FYI, the TOTAL INVOICED amount that is showing(in the screenshot) at this time was generated by me selecting the proper fields.  My intention is to automate formula and make the 'Paid' field a function of it.

Mike Wilday

=sumif([Paid]:[Paid], 1, [Amount]:[Amount]

That formula should do the trick. checkboxes are 1 if checked and 0 if not. Basically the formula is looking at the range of the paid column and anywhere there is a 1 it is summing the amount. 

amy16451

Thank you, Mike!  I've got this formula in, but I'm getting #BLOCKED

=sumif([Paid]:[Paid], 1, [Amount]:[Amount]

Is the formula that is typed into the cell.

I recognize that #BLOCKED means that one of the cells has an error.  There are some cells that have paid unchecked.  Do I have to account for that in the formula.(Note lower entries in the screenshot)

Any thoughts?

 

 

amy16451

Mike - I figured it out!  I had other things lower in that column so I needed to limit the rows.  Thank you so very much!!  I'm new to formulas so every bit of help counts!

If you live near Maryland, I owe you lunch!!

Mike Wilday

Haha. Glad you figured it out! I am on the west coast. So, no go. Enjoy!