Thread: SUM function won't allow more than 30 non-adjacent cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default SUM function won't allow more than 30 non-adjacent cells
Try this:

=SUM(up_to_30_cells) + SUM(up_to_another_30_cells) etc

Hope this helps.

Pete

On Apr 27, 2:38 pm, 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