I'm working on a vacation schedule at work. I have a formula that sums the associates hours for each day, and subtracts out things like vacation time, projects, meeting time and also adds back in overtime. I have a formula that works. However, I need to drag the formula down by thousands of rows and I'm unable to do this because there are 15 rows in between each "Vacation Total" row. This is the formula I am using - =(SUMIF($E$3:$E$7,$D$850,$F3:$F7))-(F850+F851+F853+F854+F855)+F852
It's difficult to explain so I'm attaching a copy of the Excel file. I've manually updated the formulas on Vacation Total rows up through row 712 to reflect the correct row for the correct dates, but would really love to be able to drag the pattern down and avoid all of the hours I will spend manually updating the schedule. Thank you in advance!
Bookmarks