| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate Every 4th Cell Down!
Hey!
Need something that will Calculate evrey 4th cell without using this long process formula because this is required down the whole sheet. =C9+C13+C17+C21 Example: Total = 9 C9 = 1 C13 = 1 C17 = 5 C21 =2 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Every 4th Cell Down!
You can try this:
Create a helper cell in Column D. In Cell D9, enter this formula: =IF(MOD(ROW()-5,4)=0,C9,"-") Copy downwards. HTH. "Killer" wrote: Hey! Need something that will Calculate evrey 4th cell without using this long process formula because this is required down the whole sheet. =C9+C13+C17+C21 Example: Total = 9 C9 = 1 C13 = 1 C17 = 5 C21 =2 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Every 4th Cell Down!
Correction:
=IF(MOD(ROW()-1,4)=0,C9,"-") In Cell D9, enter this formula: =IF(MOD(ROW()-5,4)=0,C9,"-") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Every 4th Cell Down!
Try this:
=SUMPRODUCT(--(MOD(ROW(C9:C100)-ROW(C9),4)=0),C9:C100) -- Biff Microsoft Excel MVP "Killer" wrote in message ... Hey! Need something that will Calculate evrey 4th cell without using this long process formula because this is required down the whole sheet. =C9+C13+C17+C21 Example: Total = 9 C9 = 1 C13 = 1 C17 = 5 C21 =2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a cell calculate percentages of another cell. | Excel Discussion (Misc queries) | |||
| Can you calculate a cell name? and How to return a value from an adjacent cell? | Excel Worksheet Functions | |||
| if cell has date value how to calculate other cell values | Excel Discussion (Misc queries) | |||
| Cell calculate only once | Excel Worksheet Functions | |||
| I want to calculate 3 different % from the same cell | New Users to Excel | |||
Linear Mode
