Forum Discussion
SUMIFS formula
Hi, I'm trying to write a SUMIFS formula that will sum a total duration based off of a condition rating but stop once it hits a duration value of zero. For example please see my current formula:...
Jmarch7500 -Please check if this works. Attached file has conventional excel formals if you are using older version of Excel
=SMALL(IF(L5:L27=0,SCAN(0,L5:L27,LAMBDA(X,Y,X+Y))),1)