|I am in need of finding the average time it takes someone to clean a peice of equipment. I have 4 peices of equipment. I also have 3 shifts. What I need to do is see if the shift cleaned the equipment and then average the time it took that shift to clean that peice of equipment. Here is what i've tried but of course it doesn't work.|
SUMIF('6000 N'!B:B & '6000 N'!E:E, "Automation" & "1a", '6000 N'!C:C)/COUNTIF('6000 N'!B:B & '6000 N'!E:E,"Automation" & "1a")
I can get the formula to work for accross all shift with this
=SUMIF('6000 N'!B:B, "Automation", '6000 N'!C:C)/COUNTIF('6000 N'!B:B,"Automation")
I tried to get my sumif to look at both the B collum where my equipment name is stored and in collumn E where my shift is stored the time it took to clean the equipment is stored in collumn C. All data is going in one workbook and then on a seperate workbook I am going to keep the averages and really would like it to be automated so I don't have to spend time going threw and manually updating the averages. Any suggestions??