Formulas

[Simon]

Can anyone help???

I am looking for a formula to select "Visa Payments" in
one column and then count the payments in another column
which will then calculate the total Visa payments.

 

[JE McGimpsey]

One way:

=SUM(A1:A100,"Visa Payments",B1:B100)


Where "Visa payments" are in column A, and the amounts in column B.

 

[Frank Kabel]

Hi Simon
if the text 'Visa Payments' is in column A and your amounts in column B
use
=SUMIF(A1:A1000,"Visa Payments",B1:B1000)

 

[Frank Kabel]

Hi JE
you probably meant
=SUMIF(A1:A100,"Visa Payments",B1:B100)


Frank