Noncontiguous cell range

J

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
 
T

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
Click to expand...

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