Thread: SUM function won't allow more than 30 non-adjacent cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default SUM function won't allow more than 30 non-adjacent cells
Very messy but try:-

=sum(No1 to No30)+sum(No1 to No30)

Mike

"juanfranela" wrote:

When writing a SUM formula, I am unable to incorporate more than 30
non-adjacent cells into my formula. Is there a way around this limit besides
using subtotals?
Reply With QuoteReply With Quote