I'm in the process of creating a staff holiday planner. What I need is to create a summary worksheet, that will add up the total number of staff available over a month or weekly period.
If I haven't explained that well, staff will select a cell if they won't be in on that day, that cell will then auto format to a specific colour and also have a text value indicating the type of holiday leave taken.
If an employee is in work and therefore available, the cell will be completely blank (no formatting and no text value). Is it possible to use a vlookup (or similar) to search the worksheet for cells without any value inside, and bring a total number to a summary page to show the amount of staff in work over that week or month?
This is my first attempt at creating anything from scratch in Excel so although I'm familiar with some terms, the actual functions are a bit alien to me. Unfortunately most google queries bring up guidance that flies over my head.
Bookmarks