Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I increase the number of cells I want to total
I'm trying to total
=SUM(D3,D11,D19,D27,D35,D43,D51,D59,D67,D75,D83,D9 1,D99,D107,D115,D123,D131,D139,D147,D155,D163,D171 ,D179,D187,D195,D203,D211,D219,D227,D235) I need to extend this further but can't add any more do to error. How can I add more cells to calculate? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I increase the number of cells I want to total
Excel has sum limitation on "SUM".
please try with subtotal, available in "Data" menu. *** Please do rate *** "acking62" wrote: I'm trying to total =SUM(D3,D11,D19,D27,D35,D43,D51,D59,D67,D75,D83,D9 1,D99,D107,D115,D123,D131,D139,D147,D155,D163,D171 ,D179,D187,D195,D203,D211,D219,D227,D235) I need to extend this further but can't add any more do to error. How can I add more cells to calculate? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I increase the number of cells I want to total
First, you don't need SUM() at all in this case. A simple
=D3+D11+D19.... will do. SUM() is usually used for quickly adding contiguous ranges, like =SUM(D1:D9) [would add all values in D1, D2, D3, D4, D5, D6, D7, D8 and D9 By removing the SUM() function from your statement, you get away from the limit on number of cells referenced in it, and you move on to a much larger limit for the total size of contents of a formula. "acking62" wrote: I'm trying to total =SUM(D3,D11,D19,D27,D35,D43,D51,D59,D67,D75,D83,D9 1,D99,D107,D115,D123,D131,D139,D147,D155,D163,D171 ,D179,D187,D195,D203,D211,D219,D227,D235) I need to extend this further but can't add any more do to error. How can I add more cells to calculate? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I increase the number of cells I want to total
Try something like this:
This function sums D3 and every eighth cell below it. =SUMPRODUCT((MOD(ROW(D3:D1000)-3,8)=0)*D3:D1000) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Naveen" wrote: Excel has sum limitation on "SUM". please try with subtotal, available in "Data" menu. *** Please do rate *** "acking62" wrote: I'm trying to total =SUM(D3,D11,D19,D27,D35,D43,D51,D59,D67,D75,D83,D9 1,D99,D107,D115,D123,D131,D139,D147,D155,D163,D171 ,D179,D187,D195,D203,D211,D219,D227,D235) I need to extend this further but can't add any more do to error. How can I add more cells to calculate? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |