I am using an array sumifs formula to add up all the data that meets two criteria. the criteria are a persons name and the date. n The formula is working great but I need to add two more variable to the mix. What I am returning is the total pcs picked during the day. I need to break that down to hour increments. So, instead of the total number picked today i need the amount picked during hour one, hour two, hour three and so on.
I thought the best way to do this was to add an if logic test to the back of the formula saying if the time is greater than or equal to this time and lesser than or equal to this time then sum the data to return the number. The formula is missing something however. I am not proficient enough yet to correct the problem.
This is the formula I am trying to create.
=SUMIFS('SAP Data'!$K$2:$K$1048575,'SAP Data'!$A$2:$A$1048575,C4,'SAP Data'!$J$2:$J$1048575,F4)IF('SAP Data'!$K$2:$K$1048575,<=Sheet2!A6,IF('SAP Data'!K2:$K$1048575,>=Sheet2!B6))
The formula is in A8 on the sheet2 page of the workbook.
Bookmarks