Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
averages/if formulas-need help ASAP!!
I have two columns: one has initials of person completing the task, next to
it is the percentage of work that is equal to. At the bottom, I am hoping to have two tables depicting the average % of work and total % of work for each person. I've tried =average(e3:e23 (if(d3:23="dj")) Basically I have no idea how to create a correspondence between the name and % of work...HELP! I'm so confused I can't even really explain my problem :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
averages/if formulas-need help ASAP!!
I've tried =average(e3:e23 (if(d3:23="dj"))
That's pretty close! Try it like this... Array entered** : =AVERAGE(IF(D3:D23="dj",E3:E23)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Laurel" wrote in message ... I have two columns: one has initials of person completing the task, next to it is the percentage of work that is equal to. At the bottom, I am hoping to have two tables depicting the average % of work and total % of work for each person. I've tried =average(e3:e23 (if(d3:23="dj")) Basically I have no idea how to create a correspondence between the name and % of work...HELP! I'm so confused I can't even really explain my problem :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
averages/if formulas-need help ASAP!!
The only problem is that it isn't averaging the %s specific to "DJ" here is
what it looks like (a little more complex than intially said): col D col e col f col g col h col I DJ 25.00% LK 60.00% BP 15.00% DJ 25.00% RH 60.00% LK 15.00% DJ 25.00% DJ 60.00% LK 15.00% LK 25.00% KM 60.00% LK 15.00% KM 25.00% 60.00% 15.00% LK 25.00% 60.00% 15.00% BP 25.00% 60.00% 15.00% So every time I enter DJ in columns d, f and h, I want to have running average at the bottom of the corresponding #s in columns e,g and I. When I did {=AVERAGE(IF(D3:D23="dj",E3:E23))}, it came back with .25, which is not right. Does that make sense? "T. Valko" wrote: I've tried =average(e3:e23 (if(d3:23="dj")) That's pretty close! Try it like this... Array entered** : =AVERAGE(IF(D3:D23="dj",E3:E23)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Laurel" wrote in message ... I have two columns: one has initials of person completing the task, next to it is the percentage of work that is equal to. At the bottom, I am hoping to have two tables depicting the average % of work and total % of work for each person. I've tried =average(e3:e23 (if(d3:23="dj")) Basically I have no idea how to create a correspondence between the name and % of work...HELP! I'm so confused I can't even really explain my problem :) . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
averages/if formulas-need help ASAP!!
When I did {=AVERAGE(IF(D3:D23="dj",E3:E23))},
it came back with .25, which is not right. What result do you expect? Based on that formula and the posted sample data the correct average is 0.25 and if you format the cell for Percentage you'll get 25.00%. -- Biff Microsoft Excel MVP "Laurel" wrote in message ... The only problem is that it isn't averaging the %s specific to "DJ" here is what it looks like (a little more complex than intially said): col D col e col f col g col h col I DJ 25.00% LK 60.00% BP 15.00% DJ 25.00% RH 60.00% LK 15.00% DJ 25.00% DJ 60.00% LK 15.00% LK 25.00% KM 60.00% LK 15.00% KM 25.00% 60.00% 15.00% LK 25.00% 60.00% 15.00% BP 25.00% 60.00% 15.00% So every time I enter DJ in columns d, f and h, I want to have running average at the bottom of the corresponding #s in columns e,g and I. When I did {=AVERAGE(IF(D3:D23="dj",E3:E23))}, it came back with .25, which is not right. Does that make sense? "T. Valko" wrote: I've tried =average(e3:e23 (if(d3:23="dj")) That's pretty close! Try it like this... Array entered** : =AVERAGE(IF(D3:D23="dj",E3:E23)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Laurel" wrote in message ... I have two columns: one has initials of person completing the task, next to it is the percentage of work that is equal to. At the bottom, I am hoping to have two tables depicting the average % of work and total % of work for each person. I've tried =average(e3:e23 (if(d3:23="dj")) Basically I have no idea how to create a correspondence between the name and % of work...HELP! I'm so confused I can't even really explain my problem :) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas: Averages | Excel Discussion (Misc queries) | |||
Need help with monthly averages, and copying formulas | Excel Worksheet Functions | |||
NEED HELP ASAP PLEASE!! | Excel Discussion (Misc queries) | |||
NEED HELP ASAP!! | Excel Discussion (Misc queries) | |||
How can I save the formulas when running a macro? Need ASAP!! | Excel Discussion (Misc queries) |