SUMIF with Certain Criteria

S

SPKNout4CHRIST

I need to get the sum of numbers in a column if they have a certai
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 zi
code 11111 it would be 600 and for zip code 55555 it would be 150.

Thanks and God bless in advance for the help
 
I

isabelle

hi,

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


--
isabelle



Le 2012-06-08 12:16, SPKNout4CHRIST a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif or Better Alternative? 2
Complex problem probably easy answer 2
Carrying out calculations on segments of data from within a workbo 1
Formula Help 5
Working on segments of data from within a list 1
VLOOKUP or SUMIF for Multiple Criteria 2
SUMIF with criteria "<>" & "=" 4
Overwriting a cell with a formula without deleting the formula 1

Top