I am trying to see up a employee review report. I have the following columns
Low med medh High
_x_ ___ ___ ____
___ _x_ ___ ____
___ _x_ ___ ____
___ ___ ___ __x_
_1_ _2_ _0_ _1__ Overall
I put an X in whichever column is scored. Now I have the following formula to count the number of x's in each column
=COUNTIF (G29:G40,"x") so I would then have number totals
in the overall columns. So what I want to do is have each of those columns low, med, medh, high equal an average. for example if "X" is in low low is 1.00 to 1.74, med is 1.75 to 2.74 and medh is 2.74 to 3.74 and high is 3.75 to 4.00
So I want to take the total number in the overall section and put in a formula with the above ranges and then get an total overall averge score for all the columns. I don't know if I have explained this correctly or even if it can be done. Any suggestions??
Thanks
Debbie
Low med medh High
_x_ ___ ___ ____
___ _x_ ___ ____
___ _x_ ___ ____
___ ___ ___ __x_
_1_ _2_ _0_ _1__ Overall
I put an X in whichever column is scored. Now I have the following formula to count the number of x's in each column
=COUNTIF (G29:G40,"x") so I would then have number totals
in the overall columns. So what I want to do is have each of those columns low, med, medh, high equal an average. for example if "X" is in low low is 1.00 to 1.74, med is 1.75 to 2.74 and medh is 2.74 to 3.74 and high is 3.75 to 4.00
So I want to take the total number in the overall section and put in a formula with the above ranges and then get an total overall averge score for all the columns. I don't know if I have explained this correctly or even if it can be done. Any suggestions??
Thanks
Debbie