(AK) | (AL) | (AM) | |
SUBJECT | HR ACHIEVED | HR NOT ACHIEVED | STANDARD |
112)MICROSOFT SQL | 5:25 | 6:35 | 12:00 |
113) XCEL OR ACCESS | 2:19 | 0:19 | 2:00 |
114)YOUTUBE | 0:00 | 2:00 | 2:00 |
115)RESEARCH | 1:27 | 2:33 | 4:00 |
116) READING(EXCEL&OTH | 1:54 | 6:06 | 8:00 |
117) JUBILEE ASSOCIATES | 5:04 | 1:04 | 4:00 |
118) FORBES(READING) | 2:17 | 2:43 | 5:00 |
119)CATCH-UP (sat &sun) | 0:00 | 0:00 | 0:00 |
SUM 1 | 18:26 | #VALUE! | 181:00 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:6546;width:134pt" width="179"> <col style="mso-width-source:userset;mso-width-alt:5668;width:116pt" width="155"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
THE PROBLEM IS I WISH TO SUM ONLY VALUES (HOURS NOT ACHIEVED) WHERE HOURS ACHIEVED IS GREATER THAN THE STANDARD HOURS E.G AL113+AL117. CAN'T THERE BE ANY AUTOMATED CODE? I TRIED USING THIS SUMIFS(AK112:AM119,AL112:AL119,AK112>AM112,AL112:AL119,AK113>AM113,AL112:AL119,AK114>AM114,AL112:AL119,AK115>AM115,AL112:AL119,AK116>AM116,AL112:AL119,AK117>AM117,AL112:AL119,AK118>AM118,AL112:AL119,AK119>AM119) BUT IT NEVER WORKED. PLEASE HELP ME OUT.
THANKS
REGARDS,
CHIBS