Thread: Summing non contiguous cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default Summing non contiguous cells
Try creating four 10-cell non-contiguious RangeNames.....(hold down Ctrl
while selecting the cells).........then SUM them by RangeName

=SUM(Range1,Range2,Range3,Range4)

Vaya con Dios,
Chuck, CABGx3



"Millie" wrote:

I am trying to sum 44 non contiguous cells. But after I do about 30, it no
longer allows me to select them. Is this something in Excel 2003? A setting I
can change?
Reply With QuoteReply With Quote