Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing the name and the column and getting an average (for sales people)
Here is the function (array) I just got the hang on: {=AVERAGE(IF($C$2:$C$80=A84,$I$2:$I$80))} What it allows me to do is to type "Joe" into cell a84 it will bring up his average in column I (which will get bigger fairly fast) What I need it to do is allow me to select the column I want it to take the average from. The data I have is survey data, checking up on a particular staff member. Right now, i can find out how anyone is doing on question one (the I column) but what I need to try and figure out is how to adjust the data column that is being used for the average. Right now, I have to replicate this formula 10 times with some modification so that each question has a cell that you can type a name into, giving you a percentage result. Question 1 Enter: [Joe] 93.7% Question 2 Enter: [Joe] 99.9% Brackets show what you have to type each time to get a reply. What I would like is [S1] [Joe] 99.3% 2 cells where 1 cell selects the name and the other selects the column to take the average from. 1 output cell that just displays the current percentage. -- furryfishus ------------------------------------------------------------------------ furryfishus's Profile: http://www.excelforum.com/member.php...o&userid=34811 View this thread: http://www.excelforum.com/showthread...hreadid=545678 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing the name and the column and getting an average (for sales people)
I've just responded to your other post (which is very similar to this).
I forgot to mention to commit that formula with CTRL-SHIFT-ENTER instead of just ENTER. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|