Greetings - Haven't been to board in a while but have something that may be tricky so I turned to the pros!!!
Given:
<colgroup><col></colgroup><tbody>
</tbody>
I need to calculate the Average not including the 0%'s after the current week. However - this person was on PTO the 1st week so I DO need to count that Zero. I've used this formula int he past =AVERAGEIF(R5:R17,"<>0") to ignore zeros but it breaks when I have a legit 0 that needs to be factored in.
Any suggestions??
Given:
<tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>
I need to calculate the Average not including the 0%'s after the current week. However - this person was on PTO the 1st week so I DO need to count that Zero. I've used this formula int he past =AVERAGEIF(R5:R17,"<>0") to ignore zeros but it breaks when I have a legit 0 that needs to be factored in.
Any suggestions??