Sum for past five days

[xeven_]

I have a column of numbers in column C. I want to sum the prior five days in column D. Is there a formula that will help me do this?
Something like below

0.35%​
-0.28%​
0.49%​
0.67%​
-0.29%​	0.94%​
0.70%​
-0.15%​
0.19%​
0.84%​
0.39%​	1.96%​
-0.27%​
0.03%​
0.11%​
-0.90%​
-1.57%​	-2.60%​
1.01%​
-0.09%​
0.31%​
-1.77%​
0.73%​	0.19%​
1.50%​
1.13%​
0.33%​
-0.54%​
0.73%​
0.17%​

 

[saeedkk]

Hello,

the sum function if started at the fifth row can be dragged down and I m sure you are familiar with that, so I think what you are asking about is that you want to only display the values in the specific rows that you are showing which can be solved by

=IF(MOD(ROW(B5),5)=0,SUM(A1:A5),"")

 

[xeven_]

Hello,

the sum function if started at the fifth row can be dragged down and I m sure you are familiar with that, so I think what you are asking about is that you want to only display the values in the specific rows that you are showing which can be solved by

=IF(MOD(ROW(B5),5)=0,SUM(A1:A5),"")

AWESOME THANK YOU!!!!