Hi,
I'm really hoping someone can help me here. I'm new to using formulas in excel and doing anything above basic and I've tried hours of research online and no matter how many different ways I google what I want, I cannot for the life of me find out a way to do what I want.
I have a table with the columns Staff ID, First Name, Surname, and then a metric such as Tool usage or Talk Time. I enter data into this table everyday with the previous days values for each heading.
What I'd now like to do is have another table with a list of my staff and I'd like to calculate how many times a particular staff member appears in the other table and then calculate the average "score" of the metric IE Talk time.
Please please can someone help me it's driving me crazy. I feel like it's something so simple but none of the videos or websites I've looked at so far have helped in anyway and I'm 4 hours down.
Bookmarks