Formula to sum the performance by tenure of employees

[ajay_psingh25]

I am analyzing the data for my employees, i have prepared a running spreadsheet for their daily performance, which also translates their weekly and monthly performance.Now, i want to bucketize their the employee performance by their tenure.for example what is the total no.of claims the employees between 0-3 months did, how much time they took.How many fields they processed and how many errors they made.
Similarly for employees between 4-6 months and 7 months - 1 yr and above 1 yr.

I am enclosing the sheet that i have made, i want the results in row 5,6,7 and 8 for each day. I would help me streamline the current project, any help would be highly appreciated.

[dredwolf]

Not quite sure what you are looking for in rows 5,6,7...an individual employees performance, or the whole companies performance?
If individual employee, is the answer to be based on you selecting their name or id number, or citrix(?) ?
If whole company, is it supposed to be an average of, a total of or something else?

A sample of the expected result, and how you arrive/expect to arrive at the result, would definitely help.

[Moo the Dog]

Try these:

In cell AT5: =SUMIF($F$11:$F$146,"<=3",AT$11:AT$146)
In cell AT6: =SUMPRODUCT(($F$11:$F$146>3)*($F$11:$F$146<7)*(AT$11:AT$146))
In cell AT7: =SUMPRODUCT(($F$11:$F$146>6)*($F$11:$F$146<13)*(AT$11:AT$146))
In cell AT8: =SUMIF($F$11:$F$146,">12",AT$11:AT$146)

- Moo

[Moo the Dog]

Those can be copied and pasted under Time, Fields and Errors. Won't work for CPH or % columns though.

- Moo

[Moo the Dog]

Since you are using Excel 2007, which makes use of SUMIFS, you could also use:

In AT6: =SUMIFS(AT$11:AT$146,$F$11:$F$146,">3",$F$11:$F$146,"<7")
In AT7: =SUMIFS(AT$11:AT$146,$F$11:$F$146,">6",$F$11:$F$146,"<13")

- Moo