Hi

Im trying to count various items in a column, but not all. I can either do
this by stipulating a range of items or using a wildcard. However, Sumproduct
is not returning any results when I use more than one item/criteria for a
specified column.

Example:
=SUMPRODUCT((A2:A60000=€�Debit Order€�)*(B2:B60000=€�Not Affordable due to*))
Or
=SUMPRODUCT((A2:A60000=€�Debit Order€�)*(B2:B60000=€�Not Affordable due to
nett)*(B2:B60000=€�Not Affordable due to gross))

Both results gives me a 0 result. I tried replacing the * with ,-- and , and +

Any advice?

Regards

EricB