Add column based on contents of another

[jhepn]

Anyone know how to add the contents of one column based on the contents of another? I've done this before (long time ago) but can't remember. I think it was a sumproduct formula, but can't seem to make it work. Basic layout is below:
2;3;4;5;6
2;1;5;4;2
5;3;4;2;6
3;1;4;5;8
2;4;5;2;1

Where I'd like to add all the numbers in the 5th column if the number in the first is a 2 (so in this scenario, the result would be 6+2+1=9). Any help would be great! Thanks!

 

[John Davis]

Anyone know how to add the contents of one column based on the contents of another? I've done this before (long time ago) but can't remember. I think it was a sumproduct formula, but can't seem to make it work. Basic layout is below:
2;3;4;5;6
2;1;5;4;2
5;3;4;2;6
3;1;4;5;8
2;4;5;2;1

Where I'd like to add all the numbers in the 5th column if the number in the first is a 2 (so in this scenario, the result would be 6+2+1=9). Any help would be great! Thanks!

How about:

=SUMIF(A1:A6,"=2",E1:E5)

 

[tweedle]

Here's the SumP version:

=SUMPRODUCT(--(A5:A9=D2),--(E5:E9))
D2 has my criteria value (your '2')

(CTRL+SHIFT+ENTER to commit the formula)