Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif when criteria range is larger but includes criteria | Excel Programming | |||
sumif when criteria range is larger but includes criteria | Excel Programming | |||
Sumif with two Criteria | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
sumif criteria | Excel Programming |