Home > front end >  Sumif formula for chosen criteria ranging this date of to this date
Sumif formula for chosen criteria ranging this date of to this date

Time:10-29

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. enter image description here

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.

  • Related