hi guys so im having trouble with this sumif. i can make other formulas to work for simple sumifs. but this one is not working. im trying to sum this given criterion
=SUMIFS($C$4:$C$33,$B$4:B$33,$A$4:$A$33,">"&$G$6,$H6,$A$4:$A$33,"<="&I6)
here is the sample sheet im playing with before doing it to the actual sheet.
this is what i want to happen
ex. if "Line 1" is chosen how many minutes it consume during this dates from 8-july-22 upt to 13-aug-22.
CodePudding user response:
You need to use the formula like as given below, SUMIFS()
syntax was not applied in correct order.
=SUMIFS($C$4:$C$33,$B$4:$B$33,$G6,$A$4:$A$33,">="&$H6,$A$4:$A$33,"<="&$I6)
Learn how to use SUMIFS() Function from Microsoft Documentation.