I need help with an Excel Formula. I am creating a gradebook using points and not values for grades. For examples, E5:BE5 represents the total points possible for each assignment, E6:BE6 represents the actual points received, and E7:BE7 represents attendance. BD7 will sum E5:BE5, BC7 will sum E6:BE6, and BC6 will give the percent grade. My problem is when a new student comes in during the middle of marking period, I only want to add the total points from the point when he/ she entered. In other words, in E7:BE7 (attendance line) I want to put an "n" for new and in BD7 I wantto have a formula that states "if there is an "n" in E7:BE7 to sum only the cells of E5:BE5 that are after the column that "n" is in". Is this possible?