Thread: SUM function settings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default SUM function settings
George,

=Sum(a1,a3,etc to 30)+Sum(b1,b2 etc up to another 30)

Mike

"George" wrote:

Hello
The SUM function allows up to 30 numbers to be added
=SUM(number1;number2;;;numbern;;;number30). Is there a way to modify
the settings of this function to accommodate more numbers?

Reply With QuoteReply With Quote