View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
docbehr docbehr is offline
external usenet poster
 
Posts: 3
Default sorting and adding totals

I need help with a formua that will search through the initals in the right
coloumn and add the totals in the left coloumn according to the initials in
the right. any suggestions? here is an example of what I am talking about


650.65 VB
197.00 JB
228.00 JB
410.00 KMM
361.53 KMM
3,982.00 VB
2,200.00 VB
498.48 JB
172.00 KMM
511.57 KMM
644.69 VB
184.26 VB
290.00 VB
969.00 KMM
198.00 JB
500.00 PB