Try this:

=SUMIF(A1:A4,"Chq",B1:B4)

--
Biff
Microsoft Excel MVP


"ZIPPOMA NEEDS HELP" wrote in
message ...
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