SUMPRODUCT or SUMIF would both accomplish this:

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

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

HTH
Elkar


"docbehr" wrote:

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