Sum column only of rows that match a condition (of another column)

Question

I have a spreadsheet in Google with the following data:

**Status         Amount**
Under Review    $120.00
Delivered       $50.00
Paid            $320.00
Paid            $110.00
Under Review    $200.00

I want to sum all the column Amount, only but of only of those rows that has a Status on 'Delivered' or 'Paid'

With my example, the SUM should return $480.00.

I was trying with this formula, but it isn't working

=SUMIF(Column Amount,Status={"Delivered","Paid"},Column Amount)

Any ideas? Thanks a lot!

score 4 · Accepted Answer · answered Apr 14 '20 at 05:40

4

You can also use the following formula:

=SUM(QUERY(A2:B,"select sum(B) where A='Paid' or A='Delivered' group by A"))

answered Apr 14 '20 at 05:40

marikamitsos

score 2 · Answer 2 · answered Apr 14 '20 at 02:33

2

One of your columns is incorrect, and you need to use the arrayformula function. Documentation here

=SUM(ARRAYFORMULA(SUMIF([status_column],{"Delivered","Paid"},[amount_column])))

answered Apr 14 '20 at 02:33

Joundill

2 Answers2