Forum Discussion
,Countifs -Multiple conditions
Here's a start, but I want to check before going further to see if you have a current enough version of Excel for you to be able to take advantage of the newer Dynamic Array functions. In this case, I use the FILTER function to sift through the employee list and see which ones meet your criteria.
Here's the formula:
=COUNTA(FILTER(G4:G20,H4:H20<=TODAY()*(F4:F20<>"Spain")))
This formula can have additional criteria added if needed. So, for example, if you wanted to count Males or Females distinctively, you could add that criterion as follows
=COUNTA(FILTER(G4:G20,H4:H20<=TODAY()*(F4:F20<>"Spain")*(E4:E20="Male")))
note, the * sign between the sets of criteria serves as an AND. If you wanted the equivalent of an OR you use the "+"
I'm
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.
