If:

A1= Chq B1= 100.00
A2= Sav B2= 200.00
A3=Visa B3= 50.00
A4=Chq B4= 75.00
B7= Total I am looking for

I want the total in B7 to be: Where sum of A1:A4=chq the total sum of B1:B4
equals___ In this example the total in B7 should be $175.00

Anyone have any idea if this can be done and if so how and I'll love you for
ever.

--
Thanks Everyone
Mike