Thread: Excel Formatting

I need a formula that will recognize say an account number in one column but then takes the contents of another column (the amount associated with the account number) and produces the sum. For example:
A B
5150 $465.00
5100 $315.00
5150 $400.00
5150 $600.00

How can I get the amounts of just the 5150 to add up in a cell? Hopefully this made sense and you can help me. Thank you so much!

Hello
Use the SUMIF function. As your example data.

=SUMIF($A$1:$A$4,A1,$B$1:$B$4)

Copy this down the empty column alongside, rows 1 to 4.

Thank you so much for your help!