Thread: How to make a formulae repeat every x number of rows in the same column

Hi guys,

I am really stuck on this one. I have seen many posts on, but i cant figure out how to do this!!!

I am using formula such as : =IF(OR($G56>=1,$G57>=1,$G58>=1,$G59>=1),"YES","NO"), and want it to repeat every 12 rows.

Actually what I need it to do is for the formula to repeat every day at 6:00 am. I have 3 different formulas for 3 different columns going from 6-9, 10-13, 14-17 respectively.

I just need to make the formulae above go from 6am one day to 6 pm the next day and continue for the rest of 48,000 cells

Any help is appreciated.

Another thing I wanted to do is sum them all in the end, for each month. Any ideas how to do that as well?

Thank you.

Stefan

Between this is for Microsoft Office 2007