Excel Pro Needed: two formulas for employee scheduling spreadsheet
Budget: $10 – $30 USD
This is an Excel schedule for healthcare employees.
Without corrupting the existing calendar formulas, I need two things on this sheet:
FIRST:
I need a formula in Column AN, that will show the sum of each corresponding Row that has a colored cell, but only the cells that are Monday - Friday (do not count a colored cell on Saturday or Sunday).
The color of the cell does not matter, just that it is colored, and each color has the same value (1).
For example, Row 116 should show the number 12 in column AN, row 130 should show 22, and so on.
SECOND:
In the last row of each month that is labeled “Total Daily Staff”, I need a formula that will show the sum of each column that has a colored cell.
For example, cell F136 should show 4, cell N28 should show 4, cell Q112 should show 1, and so on.
Without corrupting the existing calendar formulas, I need two things on this sheet:
FIRST:
I need a formula in Column AN, that will show the sum of each corresponding Row that has a colored cell, but only the cells that are Monday - Friday (do not count a colored cell on Saturday or Sunday).
The color of the cell does not matter, just that it is colored, and each color has the same value (1).
For example, Row 116 should show the number 12 in column AN, row 130 should show 22, and so on.
SECOND:
In the last row of each month that is labeled “Total Daily Staff”, I need a formula that will show the sum of each column that has a colored cell.
For example, cell F136 should show 4, cell N28 should show 4, cell Q112 should show 1, and so on.