View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tenny tenny is offline
external usenet poster
 
Posts: 1
Default combine rows and sum data with the same id

Hi,
Here is an example of the data I have.
Account ID Amount
101567 $505.00
101567 $875.00
101567 $2,450.50
253570 $1,178.90
253570 $875.00
346677 $1,928.33
I have thousands of accounts with multiple amounts having the same ID and I
need to add these amounts and combine them so that there is only one row per
account ID. Please help...