<div>
That worked. &nbsp;Thank you.<br />
Roger
</div>


<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for RogerKMiller's comment <a href="https://www.experts-exchange.com/questions/28171450/CountIf-function-with-Excel-formula-to-count-how-many-cells-have-the-word-Off-in-them.html?anchorAnswerId=39286856#a39286856" rel="ugc">#a39286856</a><br />
<br />
for the following reason:<br />
<br />
Quick thorough easy to understand response.
</div>


I've requested that this question be closed as follows:

Accepted answer: 0 points for RogerKMiller's comment #a39286856 [https://www.experts-exchange.com/questions/28171450/CountIf-function-with-Excel-formula-to-count-how-many-cells-have-the-word-Off-in-them.html?anchorAnswerId=39286856#a39286856]

for the following reason:

Quick thorough easy to understand response.

<div>
Thanks, but you should accept my answer if it was correct. You can press &quot;Request attention&quot; button and ask to close question properly.
</div>


Thanks, but you should accept my answer if it was correct. You can press "Request attention" button and ask to close question properly.

<div>
<div class="content wysiwyg-content">
I want to only count if the word &quot;Off&quot; is in 7 specific columns. &nbsp;They happen to be 21 columns apart, not sure that matters. &nbsp;There are other columns with the word &quot;Off&quot; but don't want to count them.<br />
Gotta be a way.<br />
Help is appreciated.
</div>
</div>


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.

CountIf function with Excel formula to count how many cells have the word &quot;Off&quot; in them.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

CountIf function with Excel formula to count how many cells have the word &quot;Off&quot; in them.

CountIf function with Excel formula to count how many cells have the word "Off" in them.