I am an assistant principal in a high school and am wanting to set up an attendance calculation spreadsheet. I have already set up some parts of it. For instance, I have columns that will count how many excused absences, unexcused absences, and tardies that students have. However, I would also like to set up additional columns that will begin counting once the unexcused absences and tardies reach 7, and I have not been able to do that. Thanks.