Hi,

I need help with a formula. I have two columns in a spreadsheet, which is laid out for example as follows (Not the actual spreadsheet) -

Column 1 Column 2
Action Taken Cost

Paid $12.99
Not Paid $0.00
Refunded $19.00
Not Paid $0.00
Paid $20.00
Refunded $9.00

I need to create a formula that will update dynamically for the total amount that was "Refunded". If column 1 says "Refunded", I want to add the totals of those values in column 2 that are in the next cell.

For example, the total refunded would be $28.00 as above. The spreadsheet does need to be laid out like above.

Thank you for your help.