Ranges and functions · Ranges and SUMWorks in: all current Excel versions, Google Sheets

A range is a block of cells

Adding eight cells one by one is tiring. A range names a whole block with its first and last cell and a colon between them: C2:C9 means C2, C3, C4 and so on, all the way to C9. That's eight cells.

A range can run down a column (C2:C9), across a row (C2:E2 is C2, D2 and E2) or cover a block (C2:E9: three columns of eight rows). Both end cells are always included.

Common mistakes
  • Using a comma: C2,C9 means just those two cells, not everything between them.
  • Forgetting the ends count: B2:B5 is four cells, B2 and B5 included.

Go deeper: SUM, AVERAGE, COUNT, MIN and MAX

Rep
ABCDEF
1RepRegionJulAugSepTarget
2Amara OseiNorth$12,400$13,100$11,800$36,000
3Ben FischerSouth$9,800$10,250$12,100$30,000
4Lina ChenEast$15,200$14,800$16,900$45,000
5Diego AlvarezWest$8,700$9,100$8,400$28,000
6Eva NovakNorth$11,200$12,600$13,900$36,000
7Farid HaddadSouth$13,300$12,900$14,100$39,000
8Grace KimEast$10,100$9,600$10,800$33,000
9Hugo MartinWest$14,500$15,800$15,100$42,000