Counting Unique Cells


Having a little trouble with a few different formulas. I have multiple sheets with the same data and data range.

Column 1 = a skill name (with multiple rows)

Column 2 & 3 are blank. If the skill is covered in column 2 or 3 an “x” is marked in that cell.


I want to search the same cell range in multiple sheets and count all the “x” cells BUT if that cell has an X in the same cell on mulitple sheets, I only wanted it counted once.

trying countif, sumproduct but i can’t seem to get it right.


any help is appreciated.

By: Tim M

Leave a Reply

Your email address will not be published. Required fields are marked *