Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Average with a 0 in the equation
I need to create a worksheet of manhours worked. Column A is number of men;
Column B is number of hours worked that day (A1*7, a2*7. etc.) with a total in B6. I need to average the number of men who worked each week in A6. [=Average (A1:A5)]. If someone is on vacation and they enter a "0" in say A2, it skews the results. I, therefore, must delete all the "0" entries. I tried finding/replacing 0 with blank, but I then get a #VALUE error in Column B. Is there a way to eliminate all 0's from the function? THANKS for any help you can give me! |
#2
|
|||
|
|||
Average with a 0 in the equation
=IF(A1:A5<0,A1:A5)
entered with ctrl + shift & enter -- Regards, Peo Sjoblom (No private emails please) "ruralkansas" wrote in message ... I need to create a worksheet of manhours worked. Column A is number of men; Column B is number of hours worked that day (A1*7, a2*7. etc.) with a total in B6. I need to average the number of men who worked each week in A6. [=Average (A1:A5)]. If someone is on vacation and they enter a "0" in say A2, it skews the results. I, therefore, must delete all the "0" entries. I tried finding/replacing 0 with blank, but I then get a #VALUE error in Column B. Is there a way to eliminate all 0's from the function? THANKS for any help you can give me! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
plotted Average | Charts and Charting in Excel | |||
Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
Averaging/Rounding Equation problem | Excel Discussion (Misc queries) | |||
What is this kind of average called? | Excel Worksheet Functions |