• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

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.
0
RogerKMiller
Asked:
RogerKMiller
  • 2
  • 2
1 Solution
 
als315Commented:
Countif can work only with continuous range. You can sum 7 countifs if you like to get results from non-continuous range:
=COUNTIF(A:A,"Off")+ COUNTIF(C:C,"Off")+ COUNTIF(E:E,"Off")+ COUNTIF(I:I,"Off")+ COUNTIF(J:J,"Off")+ COUNTIF(K:K,"Off")+ COUNTIF(M:M,"Off")

Open in new window

0
 
RogerKMillerAuthor Commented:
That worked.  Thank you.
Roger
0
 
RogerKMillerAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for RogerKMiller's comment #a39286856

for the following reason:

Quick thorough easy to understand response.
0
 
als315Commented:
Thanks, but you should accept my answer if it was correct. You can press "Request attention" button and ask to close question properly.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now