Counting days worked and Averaging Totals

I have not created a Pivot Table for my data. This is not something I have learned yet, or experimented with. I did not see at the time how this would help my situation as my Sheet is almost done except this one formula.

I could be wrong as I have no Experience with Pivot Tables, but would this be something I need to learn to fix this sitation?

Lilbpaw

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