Noncontiguous cell range
 

When I use a function like Match, Count, or another function that
specifies a range of cells, I must enter something like A3:F3. Can my
range be a set of noncontiguous cells, like A3, C3, E3, F3?

Jeff

Noncontiguous cell range
 

On Jun 15, 6:13*pm, jeffrey wrote:
When I use a function like Match, Count, or another function that
specifies a range of cells, I must enter something like A3:F3. *Can my
range be a set of noncontiguous cells, like A3, C3, E3, F3?

Jeff

CHOOSE, COUNTIFS, INDEX do not have to be contiguous.