CountIf function with Excel formula to count how many cells have the word "Off" in them.
I want to only count if the word "Off" is in 7 specific columns. They happen to be 21 columns apart, not sure that matters. There are other columns with the word "Off" but don't want to count them.
Gotta be a way.
Help is appreciated.