Countifs

[gavs73]

Would appreciate any help on this, Dear All

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

 

[etaf]

can you attach a sample on a share like dropbox or onedrive