Excel help

Can someone help me out? I have a spreadsheet for my gun club I need a good way to tally. It is shittily formatted, column A is member number, column B is target charges, but each member may have multiple lines. I need a quick formula to total target charges per person.

This is what it looks like:

1 $2.50
1 $1.50
1 $5.00
2 $3.00
4 $.25
4 $.75
5 $6.00

And so on. Is there an easy way to get to:

1 $3.50
2 $3.00
4 $1.00
5 $6.00


Bitter Bastard, who won't be doing this BS work for my gun club next year

Messages In This Thread