Totalizing same account entries

[Hydro Man]

Using Excel 2007

I have account numbers in column ‘A’ with their dollar values in column ‘B’.
What formula would I use to get an automatic account total in column ‘C’ ?
In this case account 128467 has two entries for a total of $35.00 which would show in column ‘C’
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
A B C
128467 $10.00
130456 $15.00 $15.00
128467 $25.00 $35.00
<o> </o>
Thank you,
<o> </o>
Hydro Man

 

[mtskv5]

=sumif(a:a,a1,b:b)

 

[Haseeb Avarakkan]

Hello, Try

C1, copy down...

=IF(COUNTIF(A:A,A1)=COUNTIF(A$1:A1,A1),SUMIF(A:A,A1,B:B),"")

 

[Hydro Man]

mtskv5 and Haseeb Avarakkan,

Thank you very much for your replies this helps me greatly!

I appreciate your efforts,

Hydro Man