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:...
=SUM(IF($I$5:INDEX($I:$I, AGGREGATE(15,6, ROW($K$5:$K$100)/($K$5:$K$100<>5),1)-1 ) =20360, $L$5:INDEX($L:$L, AGGREGATE(15,6, ROW($K$5:$K$100)/($K$5:$K$100<>5),1)-1 ) ))
Or like this with SergeiBaklan formula when taking into account the BRKEY values in column C in your file or the column I in the attached sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
Thank you! This did work for that particular BRKEY but I was unable to get it to run for all of them in the list, excel ended up crashing probably due to size of data set.