View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Summing non contiguous cells

Millie

Add an extra pair of parens.

=SUM((A1,A3,A4 up to 44 cells))


Gord Dibben MS Excel MVP

On Thu, 10 Aug 2006 10:15:02 -0700, 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?