Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add more that 30 noncontiguous cells in Excel
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add more that 30 noncontiguous cells in Excel
There are two easy solutions:
1. Cascade the sums - that is use more than one sum function. 2. Make your collection of disjoint cells into a name range -- Gary''s Student - gsnu200793 "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add more that 30 noncontiguous cells in Excel
You can also use multiple area references:
=SUM((A1,D2,H5,...Y57),(G127,J205,F23,...U2),(T1,T 5,T87,...T99)) The above formula contains 3 arguments. Each set of (...) is a single argument. -- Biff Microsoft Excel MVP "Egozite" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add more that 30 noncontiguous cells in Excel
I believe you could use just one argument w/multiple areas.
=SUM((A1,D2,H5,...Y57,G127,J205,F23,...U2,T1,T5,T8 7,...T99)) "T. Valko" wrote: You can also use multiple area references: =SUM((A1,D2,H5,...Y57),(G127,J205,F23,...U2),(T1,T 5,T87,...T99)) The above formula contains 3 arguments. Each set of (...) is a single argument. -- Biff Microsoft Excel MVP "Egozite" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add more that 30 noncontiguous cells in Excel
Yes, you could but I was demonstrating how it could be done wrt the number
of arguments. -- Biff Microsoft Excel MVP "JMB" wrote in message ... I believe you could use just one argument w/multiple areas. =SUM((A1,D2,H5,...Y57,G127,J205,F23,...U2,T1,T5,T8 7,...T99)) "T. Valko" wrote: You can also use multiple area references: =SUM((A1,D2,H5,...Y57),(G127,J205,F23,...U2),(T1,T 5,T87,...T99)) The above formula contains 3 arguments. Each set of (...) is a single argument. -- Biff Microsoft Excel MVP "Egozite" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average of 12 noncontiguous cells | Excel Discussion (Misc queries) | |||
Adding noncontiguous cells | Excel Discussion (Misc queries) | |||
noncontiguous cells | Excel Discussion (Misc queries) | |||
maximum for noncontiguous cells in chart? | Charts and Charting in Excel | |||
can you use countif function for noncontiguous cells | Excel Worksheet Functions |