CODEWITHSUNDEEP
excelexcel-formula
Bryan Roca
Bryan Roca

Reputation: 35

Sumif formula for chosen criteria ranging this date of to this date

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.

Upvotes: 3

Views: 179

Answers (1)

Mayukh Bhattacharya
Mayukh Bhattacharya

Reputation: 27458

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.

Upvotes: 2

Related Questions