Noncontiguous cell range

[jeffrey]

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

 

[trip_to_tokyo]

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.