View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Qull666@hotmail.com is offline
external usenet poster
 
Posts: 114
Default 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