Formulas

  • Thread starter Thread starter Simon
  • Start date Start date
S

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.
 
One way:

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


Where "Visa payments" are in column A, and the amounts in column B.
 
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)
 
Back
Top