| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Help on Average formula!!!
This is what i have
Z5:Z65=Different Names Of People AA5:AA65=If (L) is entered =Laidoff AE5:AE65= Hours worked for each name in cells Z5:Z65 In AB5:AB65 I want to Average hours of AE5:AE65 If an L is entered for each name & hours in AA5:AA65 & If there is no L entered I need a zero value in cells AB5:AB65 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help on Average formula!!!
If L is in aa5 do you wish to include the hours worked by that person? The
way you describe it will never change the average. If I underrstand correctly. So far I have =IF(AA5="L",AVERAGE($AE$5:$AE$65),0) "Mike" wrote: This is what i have Z5:Z65=Different Names Of People AA5:AA65=If (L) is entered =Laidoff AE5:AE65= Hours worked for each name in cells Z5:Z65 In AB5:AB65 I want to Average hours of AE5:AE65 If an L is entered for each name & hours in AA5:AA65 & If there is no L entered I need a zero value in cells AB5:AB65 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help on Average formula!!!
Yes i wish to include the hours that he worked
"Arceedee" wrote: If L is in aa5 do you wish to include the hours worked by that person? The way you describe it will never change the average. If I underrstand correctly. So far I have =IF(AA5="L",AVERAGE($AE$5:$AE$65),0) "Mike" wrote: This is what i have Z5:Z65=Different Names Of People AA5:AA65=If (L) is entered =Laidoff AE5:AE65= Hours worked for each name in cells Z5:Z65 In AB5:AB65 I want to Average hours of AE5:AE65 If an L is entered for each name & hours in AA5:AA65 & If there is no L entered I need a zero value in cells AB5:AB65 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AVERAGE Formula Help | Excel Discussion (Misc queries) | |||
| Average formula | Excel Discussion (Misc queries) | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Average Row Formula | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Linear Mode
