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:...
As variant and for Excel 365
=SUM( TAKE( $L$5:$L$10000, XMATCH(TRUE, $K$5:$K$10000<>5)-1 ) )