Sum a range based on a criteria

[TOM M]

Hello,

I have a list of properties and payments recording them in order received eg

Prop Payment
1 10
4 5
3 7
3 4
4 9
5 9
1 8
2 9

I then need a sum of all payments for each prop

Prop Total
1 (sum of all payments for Number 1 )
2 (sum of all payments for Number 2)
3 (sum of all payments for Number 3)
4 (sum of all payments for Number 4)
5 (sum of all payments for Number 5)

I have been trying for a while with no success. Any help is greatly appreciated.

Tom M

 

[schielrn]

Look into using Sumif:

=sumif(A:A,1,B:B)
=sumif(A:A,2,B:B)

And you can repalce the bold number with a cell reference if you want.

Change the ranges as needed.

Hope that helps.

 

[TOM M]

SUMIF worked perfectly. Thanks very much