Help to solve a formula problem

[scareycarey]

I have a problem I an trying to solve and wonder if anyone could help please.

I have 3 columns ,what I am trying to do is create a formula that IE every time the same number appeared in column A it would count the number of pallets in column C as in this instance 4275 should be 39.


A B C

decam		pallets
4275	7	24
1291	6	0
4164	6	0
1697	5	0
4275	5	15
37	0	0
44	0	0
99	0	0
176	0	0
283	0	0
490	0	0
829	0	0
1248	0	0

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[AliGW]

What is the purpose of the middle column? Is it relevant? Have a look at the SUMIF function.

 

[scareycarey]

colum c just counts how many pallets tipped for a given dcam in another sheet

 

[AliGW]

So use the SUMIF function, then. Something like:

=SUMIF(A1:A20,A1,C1:C20)