Hi - I am trying to sum the first 12 Values in a set that aren't Zero. I found a great formula from @ Dr. Steele that works great, but the problem I have is that some of my rows have less than 12 non-zero values, so for those I would like the values from the first non-zero for the next 11 rows (12 total). Below is the formula I found. I did also have to add <>0 as there is a negative task amount I wanted the formula to work on. Any ideas?
=SUM(D1:INDEX(D1:AY1,1,SMALL(IF(D1:AY1>0,COLUMN(D:AY)-COLUMN(D:D)+1),B2)))when invoked with CtrlShiftEnter and B2=12
=SUM(D1:INDEX(D1:AY1,1,SMALL(IF(D1:AY1>0,COLUMN(D:AY)-COLUMN(D:D)+1),B2)))when invoked with CtrlShiftEnter and B2=12