Hello,
I am looking to add a formula where we rollover the total points each quarter if the quarter is greater than zero for the prior quarter and add only the total points documented after there is a zero listed for a quarter. For instance if someone receives points in Quarter 1, no points in Quarter 2, but has points in Quarter 3 and Quarter 4, I want to be able to add the Quarter 3 and Quarter 4 points only since its after a quarter of no points. Vice Versa with the other Quarters.
I have the formula generated below but it still is not working:
=IFERROR(IF([Quarter 1 Total]@row <> 0, SUMIFS([Quarter 1 Total]:[Quarter 4 Total], [Employee_Name]:[Employee_Name], [Employee_Name]@row ), IF([Quarter 2 Total]@row <> 0, SUMIFS([Quarter 2 Total]:[Quarter 4 Total], [Employee_Name]:[Employee_Name], [Employee_Name]@row ), IF([Quarter 3 Total]@row <> 0, SUMIFS([Quarter 3 Total]:[Quarter 4 Total], [Employee_Name]:[Employee_Name], [Employee_Name]@row ), SUMIFS([Quarter 4 Total]:[Quarter 4 Total], [Employee_Name]:[Employee_Name], [Employee_Name]@row )))), "")
Any help is greatly appreciated.