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