If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running calculation of a frequency
Hi,
On a monthly basis I need to calculate a running frequency of scores, but I'm not sure how to do it. For example, Joe receives 3 scores (based on a 1 to 10 scale) every month and I would like to track what % of those scores are 9's or 10's. I will need to track this on a cumulative basis. Jan Feb Mar 8 7 10 9 3 9 10 9 9 9 6 10 75% 50% 67% YTD % of 9s and 10s |
#2
|
|||
|
|||
Running calculation of a frequency
=COUNTIF(OFFSET($A$2:$L$5,,,,COLUMN()),"=9")/COUNT(OFFSET($A$2:$L$5,,,,COLUMN()))
copy across "Marcia" wrote: Hi, On a monthly basis I need to calculate a running frequency of scores, but I'm not sure how to do it. For example, Joe receives 3 scores (based on a 1 to 10 scale) every month and I would like to track what % of those scores are 9's or 10's. I will need to track this on a cumulative basis. Jan Feb Mar 8 7 10 9 3 9 10 9 9 9 6 10 75% 50% 67% YTD % of 9s and 10s |
Thread Tools | |
Display Modes | |
|
|