I'd appreciate any help with this...
I'm trying to use COUNTIFS to identify patterns in customner purchases,
e.g. how many customers buy ( Product 1 and Product 2 ), or ( Product
1 and Product 2 and Product 5 ) etc.
I want to define the combinations by putting 1 or 0 in the black and white area.
It looks like it correctly identifies Product 3 / 4 / 5 as occuring once, but
it appears to be counting Product 5 three times, rather than once.
Thanks for any help.
Gav