View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default summing more than 30 numbers

If the numbers are in consecutive cells, you can group them with the colon
and only have to type the first and last cell in the series.......such as

=SUM(A1,B5,C13:C23,A25,H27:K27,....ETC ETC)

hth
Vaya con Dios,
Chuck, CABGx3



"stevientx" wrote:


I am trying to sum over 37 numbers and am being stopped at 30. Is there
a way to sum more than 30 numbers at a time?


--
stevientx
------------------------------------------------------------------------
stevientx's Profile: http://www.excelforum.com/member.php...o&userid=32349
View this thread: http://www.excelforum.com/showthread...hreadid=521050