This works but what if I add one more column where it is placing the sum of C
in D of the same in A and B combined.

a b c d
1 100 10 .50 .50
2 200 10 .75 .75
3 100 15 .15 .25
4 100 12 .23 .23
5 100 15 .1 .25


"T. Valko" wrote:

Try this entered in C1 and copied down as needed:

=SUMIF(A$1:A$5,A1,B$1:B$5)

--
Biff
Microsoft Excel MVP


"Jeremy" wrote in message
...
I am looking to sum values if other values equal. The formula needs to be
for sum in C.Please see example. This formula will be for a large range
of
data.

a b c
1 10 .50 1.25
2 10 .75 1.25
3 15 .15 .25
4 12 .23 .23
5 15 .1 .25