Summing one column if next row contains a text string

[Pabl]

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.

[tlafferty]

Assuming your labels refunded, paid etc are in column A and values to sum are in column b

=SUMIF(A:A,"=Refunded",B:B)

[TMS]

@Tom:

=SUMIF(A:A,"=Refunded",B:B) ... ?

Or just:

=SUMIF(A:A,"Refunded",B:B)


Regards

[Pabl]

Thanks guys, it works!

[TMS]

You're welcome. Thanks for the rep.

If this has answered your question, please mark your thread as solved.

Regards