Noncontiguous cell range

  • Thread starter Thread starter jeffrey
  • Start date Start date
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
 
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.
 
Back
Top