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? |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 03:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com