Forum Discussion
,Countifs -Multiple conditions
Dear Team, I am currently working on an HR Dashboard and I want to be able to use a formula to do 2 things: A. report the overall current number of employees who are still onboard. This will ...
Yes I have the newest Excel 365 with FILTER function. First time I actually heard of it. WIll read more on it! The formula worked like a charm!
Thanks!
NoviceKB
Here's a link to a YouTube video that was my own introduction not all that long ago. These are very powerful and useful functions... enjoy!
https://www.youtube.com/watch?v=9I9DtFOVPIg
As a postscript, I realize that I'd not made the formula smart enough to eliminate those whose contracts had ended, but for now I'll assume that what I did give you enables you to go ahead and fine tune. Come back with questions if you still need help.