Division on a sliding scale
I have been scratching my head for hours trying to figure out the prope
macro/formula to use in order to do division on a sliding scale. Here' what I need to do: I am creating a performance evaluation spreadsheet where users will b able to rate coworkers on their performance. There are 35 items that person is rate on, so there are 35 rows. People are rated on a scal from 1-8, so a perfect score would be 280 (35*8). The total score the (280) would be divided by 35 for their final score. However, not all 3 items apply to everyone depending on their job position. For som coworkers, 12 of the 35 items will apply to them, so I will need t divide their score by 12, not 35. I know I can do a formula do divid the score by 35 (for example: =SUM(B9/35), but I need a macro/formul that will automatically divide the score by the number of applicabl items (34, 33, 32, etc...). Is this possible? If anyone knows of formula or macro, please tell me. I have been stumped by this proble for hours. Thanks for your help in this matter -- Message posted from http://www.ExcelForum.com |
Division on a sliding scale
See m.p.worksheet.functions for replys.
Please don't post the same message in more than one newsgroup. It just tends to fragment your answers, and potentially wastes the time of those replying to questions that have already been answered. For tips on using these groups effectively, see http://cpearson.com/excel/newposte.htm In article , ultra_xcyter wrote: I have been scratching my head for hours trying to figure out the proper macro/formula to use in order to do division on a sliding scale. Here's what I need to do: I am creating a performance evaluation spreadsheet where users will be able to rate coworkers on their performance. There are 35 items that a person is rate on, so there are 35 rows. People are rated on a scale from 1-8, so a perfect score would be 280 (35*8). The total score then (280) would be divided by 35 for their final score. However, not all 35 items apply to everyone depending on their job position. For some coworkers, 12 of the 35 items will apply to them, so I will need to divide their score by 12, not 35. I know I can do a formula do divide the score by 35 (for example: =SUM(B9/35), but I need a macro/formula that will automatically divide the score by the number of applicable items (34, 33, 32, etc...). Is this possible? If anyone knows of a formula or macro, please tell me. I have been stumped by this problem for hours. |
Division on a sliding scale
Assumes names going down and questions across:
Question # 1 2 3 4 3Score Sandy 8 5 8 5 6 6.4 =SUM(B2:G2)/COUNT(B2:G2) Dan 5 8 5 6 Jil 1 5 8 5 6 5 Hope you can read this columns don't align very well. -----Original Message----- I have been scratching my head for hours trying to figure out the proper macro/formula to use in order to do division on a sliding scale. Here's what I need to do: I am creating a performance evaluation spreadsheet where users will be able to rate coworkers on their performance. There are 35 items that a person is rate on, so there are 35 rows. People are rated on a scale from 1-8, so a perfect score would be 280 (35*8). The total score then (280) would be divided by 35 for their final score. However, not all 35 items apply to everyone depending on their job position. For some coworkers, 12 of the 35 items will apply to them, so I will need to divide their score by 12, not 35. I know I can do a formula do divide the score by 35 (for example: =SUM(B9/35), but I need a macro/formula that will automatically divide the score by the number of applicable items (34, 33, 32, etc...). Is this possible? If anyone knows of a formula or macro, please tell me. I have been stumped by this problem for hours. Thanks for your help in this matter. --- Message posted from http://www.ExcelForum.com/ . |
All times are GMT +1. The time now is 05:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com