Spreadsheet: 686104d1594364752-more-efficient-counta-sumif-and-sum-formulas-needed-for-training-spreadsheet-training2
Sheet: Dashboard

[NAME]
 | Totals |  |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00
# of Sessions |  |  |  |  |  |  |  |  |  |  |  |  |  | <------
# of Expected on Training Day |  |  |  |  |  |  |  |  |  |  |  |  |  | <------
# [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | <------
New Hire Show Rate
 | [NAME]
 | B7: |  |  |  | Sum of all of the fomulas in "C6" from the other 6 tabs
 | B8: |  |  |  | Sum of all of the fomulas in "C7" from the other 6 tabs
 | B9: |  |  |  | Sum of all of the fomulas in "C8" from the other 6 tabs
 | F7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 7:00am only
 | G7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 8:00am only
 | H7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 9:00am only
 | I7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 10:00am only
 | J7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 11:00am only
 | K7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 12:00pm only
 | L7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 1:00pm only
 | M7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 2:00pm only
 | N7: |  |  |  | Count only the cells with data entered in them from the other 6 tabs but for 3:00pm only
 | F8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 7:00am only
 | G8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 8:00am only
 | H8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 9:00am only
 | I8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 10:00am only
 | J8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 11:00am only
 | K8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 12:00pm only
 | L8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 1:00pm only
 | M8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 2:00pm only
 | N8: |  |  |  | Sum "Row 7" if "Row 8" has data entereed from the other 6 tabs but for 3:00pm only
 | F9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 7:00am only
 | G9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 8:00am only
 | H9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 9:00am only
 | I9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 10:00am only
 | J9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 11:00am only
 | K9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 12:00pm only
 | L9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 1:00pm only
 | M9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 2:00pm only
 | N9: |  |  |  | Sum only the cells with data entered in them from the other 6 tabs but for 3:00pm only