Excel Sum Array Formula

[Carrie_Loos via OfficeKB.com]

Can anyone help? I don't understand how to write a simple array formula and I
need to sum up the cost values for all the Part Nbr's that are the same. For
instance Part Nbr 51008 would be $1,344.62. I would like to see this value in
column C repeated for every 51008 Part Nbr. Possible?

Part Nbr Cost
51008 $768.07
51008 $0.00
51008 $0.00
51008 $0.00
51008 $387.45
51008 $0.00
51008 $0.00
51008 $0.00
51008 $0.00
51008 $0.00
51008 $0.00
51008 $40.93
51008 $0.00
51008 $3.11
51008 $145.06
51008 $0.00
51008 $0.00
51008 $0.00
51008 $0.00
51008 $0.00
51009 $3,686.14
51009 $252.84
51009 $0.44
51009 $29.32
51009 $56.88
51009 $75.76
51009 $214.27
51009 $0.00
51009 $1,323.12
51009 $43.90
51010 $0.00
51011 $2,288.75
51018 $221.60
51030 $768.07
51030 $2.67
51030 $5,029.68

 

[PCLIVE]

Try this:

=SUMIF(A:A,51008,B:B)

HTH,
Paul

 

[Tom Ogilvy]

also look at using a pivot table report under the data menu.

 

[engoo]

You may modify the formula to refer to the corresponding value in
Column A for each row:

=SUMIF(A:A,A2,B:B)

Enter this formula in Cell C2 and copy it down for all rows..

 

[Carrie_Loos via OfficeKB.com]

Thank You, That is what I was looking for....works better not to call
anything out specifically then the list can change without having to re-
evaluate the formula.

You may modify the formula to refer to the corresponding value in
Column A for each row:

=SUMIF(A:A,A2,B:B)

Enter this formula in Cell C2 and copy it down for all rows..

also look at using a pivot table report under the data menu.

[quoted text clipped - 50 lines]

- Show quoted text -