| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
