Verticle lookup and Sum

[Tennisguuy]

I'm not sure if a vlookup is the best way to handle this but I have a some data where if the value in column A is equal to a 1 I need excel to sum the value in column D. The value in column A could appear muliple times and in row but all with in column A. For example,

A B C D
1 50 25 75
2 40 30 30
1 25 50 25
1 50 25 50

In this example formula should return a sum of 150.

 

[VoG]

Try

=SUMIF(A1:A100,1,D1:D100)

 

[Jonmo1]

Try SUMIF

=SUMIF(A1:A100,1,D1:D100)


Hope that helps.

 

[Tennisguuy]

thanks that worked