Thread: Sum formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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