Sum if against 2 veriables

March 5, 2009 at 06:57:14
Specs: Windows XP
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??

See More: Sum if against 2 veriables

Report •

March 5, 2009 at 08:00:40
I have not looked into the detail of your formulae, but I'm wondering if you either searched this forum or Googled the issue of SUMIF with multiple conditions.

It is a fairly common question that has been covered multiple times in this forum as well as in many other Excel forums on the web.

If there is something specific to your situation that can not be solved by the solutions already offered, come on back and we'll see what we can do.

Report •

March 6, 2009 at 13:13:34
I had searched this site but nothing was coming up. I did figure this problem out and anyone needing to know how I did I used daverage function. It works like a champ.

Report •

Related Solutions

Ask Question