Counting days worked and Averaging Totals

I agree that it is annoying the way this forum strips "superfluous" spaces.
I also have not tried pivot tables, however from the number of times they crop up in this forum I think this is a topic I should take the time to learn.
There are other ways, using the lookup and reference functions (in particular offset) but they can get very complicated.
Mark.

on pivot tables and I don't see how this would help me find the formula to my problem.
I have all the formulas to lay out the data exactly how I want, just not the one to find out how to count the 4 different status categories as one day so that I can get a daily average of tickets worked.

Frustrating... ugh

Lilbpaw

The function which will provide your answer is
=sumproduct()
since you can have as many criteria as you need ...

For a tailor-made answer, just upload your worksheet in a zipped format ...

HTH
Carim

The formula I need is in row aj.. such as aj3 and aj15. They will hold the average Orders Per Day calculated from the totals in the corresponding blue rows for each employee.

I have down sized it as much as I can, however it is still saying it is 221 kb which exceeds the limit of 100 kb.
Grr..
I am still trying though

Lilbpaw

Hi,

Do not forget to zip your file ...
it will drastically reduce its size ...

HTH
Carim

ok, i deleted everything possible.
The formula would be for this one employee that i can use to reference for the other employees. I hope.

The cell that needs calculation is now O3. It must figure out if the employee worked that day, how many orders were done and average them out to a daily average. Each day has 4 categories that must be seen as one day.

I hope that is not confusing.

Thank you for your help.

Lilbpaw

At first sight it is a bit confusing since the sheet Data which I suppose is tracking orders does not have any reference to the different individuals you want to track ...


Carim

I thought I saved the data in the data tab and the names in the formula tab.
then the days with the categoreis of rts, rev-rts, rev-nrts and nrts.
I had to cut out a lot of the days so that I could make the file small enough for it to upload.
This was quite difficult.
the field under OPD is where it should calculate the average after counting the orders and the days.

I believe I left 3 days, 2 where the employee worked and 1 where they didn't.
Since I have chopped that one to bits you can add anything you like or delete or move.. etc.

However notice how the blue line.. that should extend from their name is the total for each column that contains the catagories. I was trying to use these totals to calculate the average.

I wish i could have uploaded the whole thing to give you a better view of what I am talking about...


grrr.. sorry