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