ExcelBanter - Calculate Every 4th Cell Down!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculate Every 4th Cell Down! (https://www.excelbanter.com/excel-discussion-misc-queries/163119-calculate-every-4th-cell-down.html)

Killer

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

[email protected]

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

[email protected]

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,"-")

T. Valko

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

All times are GMT +1. The time now is 12:41 PM.