Thread: I want to add more that 30 noncontiguous cells in Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default I want to add more that 30 noncontiguous cells in Excel
On Wed, 18 Jun 2008 18:33:00 -0700, Egozite
wrote:

I have a string of noncontiguous cells in excel that I need the total of, but
I can't enter more that 30 using the sum function

You could use the addition operator:

=a1+b2+c3+d4+...f5:f10...+aa4+ab6...
--ron
Reply With QuoteReply With Quote