calculating the totals of a group of cells based on content of oth

[ZIPPOMA NEEDS HELP]

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.

 

[T. Valko]

Try this:

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

 

[ZIPPOMA NEEDS HELP]

Thank you soo much for taking the time. Have a very good night.

 

[T. Valko]

You're welcome. Thanks for the feedback!