Counting number of x's

[kbadge]

Does anyone know if there is a formaula I can use to calculate how many times an "X" appears in a row? I have a set of contacts in rows 6-816 and columns A-H tell who that contact belongs to. I need to know how many people or what combination of those people each contact belongs to.

[solnajeff]

Hi

Enter the following formula in the desired column in row 6

Please Login or Register  to view this content.

Drag down as far as necessary

Regards

Jeff