Forum Discussion
Solved
Use of Named Ranges in Countif formulas
It is my understanding that we can't use a named range that consists of non-contiguous cells in a countif formula. eg: COUNTIF(named_range,C280). Is that correct? If this is correct, it makes me...
You are correct, but that is not a limitation of named ranges, but of the COUNTIF function (and related functions). Other functions, such as SUM and COUNTA, work fine with named ranges consisting of non-contiguous cells.
Good to know, but still disappointing. Thanks for responding.