Sum formula
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
|