Formula Question concerning Text Cells

New Contributor

Hello,

 

In the attached screenshot, I want to know if there is a formula that will allow me to get the sum for just the amounts that coincide with the text Credit card on file and then the sum for the amounts that coincide with the text Check? Instead of the way I do it now by selecting each cell individually, I appreciate any help you can provide.

 

 

Excel Question 7-8-22.JPG

2 Replies

@TGG2000 

You can use

 

=SUMIF(C2:C100,"Credit card on file",B2:B100)

and

=SUMIF(C2:C100,"Check",B2:B100)

 

Adjust the ranges as needed.

Alternatively, create a pivot table based on the data, and add the method field to the Rows area and amount to the Values area.

Hans, I had part of the formula correct but the ranges were off. Thank you!