ExcelBanter - SUMIF with Certain Criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF with Certain Criteria (https://www.excelbanter.com/excel-worksheet-functions/446271-sumif-certain-criteria.html)

SPKNout4CHRIST

SUMIF with Certain Criteria

I need to get the sum of numbers in a column if they have a certain criteria in common in another common.

For example:

Zip Code Amount
11111 200
11111 300
55555 100
11111 100
55555 50

If the zip code is the same I need the sum of the amount, so for zip code 11111 it would be 600 and for zip code 55555 it would be 150.

Thanks and God bless in advance for the help!

isabelle

SUMIF with Certain Criteria

hi,

=SUMPRODUCT(--(A2:A6=11111)*(B2:B6))

--
isabelle

Le 2012-06-08 12:16, SPKNout4CHRIST a écrit :
I need to get the sum of numbers in a column if they have a certain
criteria in common in another common.

For example:

Zip Code Amount
11111 200
11111 300
55555 100
11111 100
55555 50

If the zip code is the same I need the sum of the amount, so for zip
code 11111 it would be 600 and for zip code 55555 it would be 150.

Thanks and God bless in advance for the help!

All times are GMT +1. The time now is 03:59 AM.