I'm quite rusty with excel so could use some help.
I've created a staff rota spreadsheet which tells people which department they'll be working in that day, and have a separate sheet that counts up this information to tell the management team how many people will be in any given department per day, for which I have the following formula:
=(COUNTIF('Rota'!D5:D182, "Area1"))
The issue I'm currently having is that the rota is split into AM/PM. If someone is in the same area all day, the PM space will be blank. I want my formula to do what it's currently doing, but with an additional format that picks up 'if[d2]isblank' alongside my previous countif formula.
Does that make sense?
I've created a staff rota spreadsheet which tells people which department they'll be working in that day, and have a separate sheet that counts up this information to tell the management team how many people will be in any given department per day, for which I have the following formula:
=(COUNTIF('Rota'!D5:D182, "Area1"))
The issue I'm currently having is that the rota is split into AM/PM. If someone is in the same area all day, the PM space will be blank. I want my formula to do what it's currently doing, but with an additional format that picks up 'if[d2]isblank' alongside my previous countif formula.
Does that make sense?