Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM function won't allow more than 30 non-adjacent cells
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM function won't allow more than 30 non-adjacent cells
=SUM((cell1,cell2,cell3, ..., cell15),(cell16,
cell17,cell18,cell30),cell(31,etc.)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "juanfranela" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM function won't allow more than 30 non-adjacent cells
Try this:
=Sum((1,2,3,4, ... 50,51,52,53 ... etc.)) It's the *double* parens that enables the extra values. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "juanfranela" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing non adjacent cells | Charts and Charting in Excel | |||
How to use SUMIF function with non-adjacent cells | Excel Worksheet Functions | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
Contents of adjacent cell from a function | Excel Worksheet Functions |