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:...
For former Excel versions that could be
=SUM( $L$5:INDEX($L:$L, AGGREGATE(15,6, ROW($K$5:$K$10000)/($K$5:$K$10000<>5),1)-1 ) )