Excel Help--Finding the Average Duration within the past month Hello, Trying to find the average duration of a project metric in the past month. =(AVERAGEIF('Onboarding Interface Tracker'!T6:T285, ">0") AND (COUNTIF('Onboarding Interface Tracker'!S6:S28... mtarlerI have anot...
You could create a spill by using =SEQUENCE(20) and then refer to the spill using # notation and COUNTIF will accept it because the values have an address in the sheet. You might also arrange the formula as such: =COUNT(IF(SEQUENCE(20)>6,SEQUENCE(20))) Excel's RACON functions | Ex...