Combining COUNTIF statements with different criteria

**Darlo** · 03-09-2007, 11:59 AM

I'm new to the forum and reletively new to Excel, but what I need to know is how to combine COUNTIF functions with different criteria.

e.g. I want to count the number of invoices paid by either switch or Maestro and display the total as one figure.

I have a data range which is in cells I17:I1273 and within this range are the varying forms of payment options written out i.e. Visa, Mastercard, Switch, Maestro etc.

Any help on this would be very much appreciated because I am stuck!

I have managed to count the number of sales containing the other criteria using the following formula as an example;

=COUNTIF(I17:I1273,"VISA")

I just don't know how to combine the criteria within the same statement.

Thanks in advance.

Darlo

Fantastic, it worked. New to the forum but I will definately be back.

Only recently started learning Excel in depth so am a novice to it.

Thanks again.

Darlo

Basically I'm trying to find out the total of invoices which are paid by creditcard on a monthly basis.

For example; I have a data range E16:E40 which contains the invoice totals, and I have column 'G' which tells me how the invoice was paid, mastercard, cash, cheque etc.

What I need to do is create a formula which will add together invoice amounts only if the word 'mastercard', 'visa', 'switch' or 'maestro' are displayed in column 'G' - therefore ignoring invoice totals which are paid by another means.

Any help would be appreciated.