sorting and adding totals

  • Thread starter Thread starter docbehr
  • Start date Start date
D

docbehr

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
 
SUMPRODUCT or SUMIF would both accomplish this:

=SUMPRODUCT(--(B1:B100="VB"),A1:A100)

=SUMIF(B1:B100,"VB",A1:A100)

HTH
Elkar
 
Back
Top