Hello,
Please be gentle, I'm new.
I'm working on a roster in excel.
It is setup as col A persons skill lvl (0,1,2 or 3)
col B persons name
col C - ?? days of the month
Now lets say we have rows 3 - 10 with persons 1-8
Persons 1-4 are working a day "d"
persons 5-8 are working a late "l"
I have a countif at the bottom counting the number of ppl on "d"
That part is working fine.
Now the problem
Under my countif telling me that there are 4 ppl on day I want to know how many OF THOSE PPL are a skill lvl >2 (listed in col A to the left of the name).
Can this be done with some sort of vlookup and/or a count of some sort?
Hope this makes sense.
I'm hoping to avoid VBA and want to achieve this via formula.
Thanks in advance.
Matt.
Please be gentle, I'm new.
I'm working on a roster in excel.
It is setup as col A persons skill lvl (0,1,2 or 3)
col B persons name
col C - ?? days of the month
Now lets say we have rows 3 - 10 with persons 1-8
Persons 1-4 are working a day "d"
persons 5-8 are working a late "l"
I have a countif at the bottom counting the number of ppl on "d"
That part is working fine.
Now the problem
Under my countif telling me that there are 4 ppl on day I want to know how many OF THOSE PPL are a skill lvl >2 (listed in col A to the left of the name).
Can this be done with some sort of vlookup and/or a count of some sort?
Hope this makes sense.
I'm hoping to avoid VBA and want to achieve this via formula.
Thanks in advance.
Matt.