Good day, I've searched and have found a handful of post, but every time I try to go with what is suggested I get an error or the new SPILL. I have sheet one which is the input data and I'm trying to show on sheet two the % of work each person has for that week to load a visual. I've used SUMIF and get the wrong number and SUMIFS returns errors. Can you please help me in the right direction on what I'm doing wrong?
=SUMIF(Sheet1!$D$2:$D300,">"&$C$1,INDEX(Sheet1!A$1:AZ3000,MATCH($A2,Sheet1!A$1:AY$1,0),0))
=SUMIFS(INDEX(Sheet1!A1:AZ3000,MATCH(A2,Sheet1!A1:AY1,0),0),Sheet1!D$2:D300,">"&D1,Sheet1!F2:F300,"="&"WORKING")
I couldn't figure out how to upload the Excel file...
Thanks!
=SUMIF(Sheet1!$D$2:$D300,">"&$C$1,INDEX(Sheet1!A$1:AZ3000,MATCH($A2,Sheet1!A$1:AY$1,0),0))
=SUMIFS(INDEX(Sheet1!A1:AZ3000,MATCH(A2,Sheet1!A1:AY1,0),0),Sheet1!D$2:D300,">"&D1,Sheet1!F2:F300,"="&"WORKING")
I couldn't figure out how to upload the Excel file...
Thanks!