Skip to main content
added 12 characters in body
Source Link
serenesat
  • 10k
  • 30
  • 33
  • 50

You might try to add {}{} brackets around a noncontiguous range in a formula. 

For example: =COUNTIF({A3,C3,E3,G3,I3}, true)

=COUNTIF({A3,C3,E3,G3,I3}, true)

You might try to add {} brackets around a noncontiguous range in a formula. For example: =COUNTIF({A3,C3,E3,G3,I3}, true)

You might try to add {} brackets around a noncontiguous range in a formula. 

For example:

=COUNTIF({A3,C3,E3,G3,I3}, true)
Source Link

You might try to add {} brackets around a noncontiguous range in a formula. For example: =COUNTIF({A3,C3,E3,G3,I3}, true)