Forum Discussion

Copper Contributor

Dec 01, 2021

Solved

COUNTIF error [SOLVED]

COUNTIF function does not seem to be working for the following scenario: 1. first sheet is skills sheet: simple list of skills and categories; type Y in a column and that employee gets the skill ...

countif error.xlsx425 KB

excel

Excel on Mac

Juliano-Petrukio
Dec 01, 2021
schiasson
countif error_SOLVED.xlsx425 KB

schiasson

Copper Contributor

Dec 01, 2021

SOLVED.

Set count range locked to longest possible list in column.

Thanks

Juliano-Petrukio

Bronze Contributor

Dec 01, 2021

Its good to know that it worked. So please flag it as solved and hit the like button.