E
EricB
Hi
I’m 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
I’m 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