get average of the same criteria/metrics

Hi All,

Need your help again.

I want to get the average score of each criteria (customer focus, driving for result, etc..)

In the output tab you can see my "manual" output.

Basically I want to average the scores under MANAGER ASSESSMENT only for all scores under the same criteria (ex. Customer Focus Criteria) with same name and same month



Thanks again in advance.

Well that is no rocketsience is it? with that data setup you will need to build it manually.. for each group of data

for cel C2 in Output use

Formula:

Please Login or Register  to view this content.

If you were to reorganize the columns so that MANAGEMENT ASSESMENT and SELF ASSESMENT are in 5 sequential columns then you could use the AVERAGE-formula

Thanks Roel,

However that method will not work. Our data has different Name on it.

Thanks PaulM100! working! will just modify it a bit more to add the name on it. but thanks for your help!

Done, Thanks!

I'm sorry

Apologies if I have offended anyone.. that was not my intention at all.
Been using that phrase for years as a Dutch equivilant of it only means "it will not be hard to fix.."

Wont use it again..