Totaling OT Hours on Separate Sheet
Closed
nowlanandrea
Posts
6
Registration date
Wednesday 15 February 2017
Status
Member
Last seen
28 February 2017
-
28 Feb 2017 à 08:29
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 7 Mar 2017 à 11:04
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 7 Mar 2017 à 11:04
Related:
- Ot excel
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Transfer data from excel to excel - Guide
- Vat calculator excel - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
28 Feb 2017 à 11:56
28 Feb 2017 à 11:56
Hi Andrea,
Create a total sheet and let us know with which data pulls you are having trouble with.
Best regards,
Trowa
Create a total sheet and let us know with which data pulls you are having trouble with.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
7 Mar 2017 à 11:04
7 Mar 2017 à 11:04
Hi Andrea,
So when you enter code 01501 in C8 of the OT sheet, you would like to know the sum of C11:D30. When you enter code 01501 in K8 as well, you would like to know the sum of C11:D30 + K11:L30.
If the above is what you are after, then I would place a sum formula in row 31.
Cell C31: =SUM(C11:D30)
Cell E31: =SUM(E11:F30)
and so on.
Now you can use the following formula:
=COUNTIF($C$8:$Z$8,"01501",$C$31:$Z$31)
You can replace the "01501" with a cell reference where that value is located.
On sheet "Sheet1" you have listed the codes in column A. When you would like to put the total in column E, your formula would be:
=COUNTIF('OT Sheet'!$C$8:$Z$8,A1,'OT Sheet'!$C$31:$Z$31)
Then drag this formula down to get the result for the other codes.
Note that "Sheet2" is empty in your uploaded file.
Best regards,
Trowa
So when you enter code 01501 in C8 of the OT sheet, you would like to know the sum of C11:D30. When you enter code 01501 in K8 as well, you would like to know the sum of C11:D30 + K11:L30.
If the above is what you are after, then I would place a sum formula in row 31.
Cell C31: =SUM(C11:D30)
Cell E31: =SUM(E11:F30)
and so on.
Now you can use the following formula:
=COUNTIF($C$8:$Z$8,"01501",$C$31:$Z$31)
You can replace the "01501" with a cell reference where that value is located.
On sheet "Sheet1" you have listed the codes in column A. When you would like to put the total in column E, your formula would be:
=COUNTIF('OT Sheet'!$C$8:$Z$8,A1,'OT Sheet'!$C$31:$Z$31)
Then drag this formula down to get the result for the other codes.
Note that "Sheet2" is empty in your uploaded file.
Best regards,
Trowa
28 Feb 2017 à 12:03
Thanks for your help!
Andrea