Hi, I would like to know how to autofill a formula so that as I drag it down a column, the column in the formula will increase by 3.
I have: E9 =COUNTIFS(Attendance!AC5:AC1000,1,Attendance!E5:E1000,"M")
I want: E10 =COUNTIFS(Attendance!AF5:AF1000,1,Attendance!E5:E1000,"M")
I want: E11 =COUNTIFS(Attendance!AI5:AI1000,1,Attendance!E5:E1000,"M")
I have been searching for hours about this, and I have come up with the offset function, the indirect function, and the index function, etc. etc. etc., and I have watched several tutorials on how to use each of these, but I am still very confused. Any help at all would be appreciated.
Bookmarks