I am trying to find out how many associates at the end of the year based on a job category.
My formula is:
"=SUMPRODUCT(--(Hire_Date<="12/31/2000"+0),((Termed>="1/1/2000"+0)+(Termed="")),--((A2="")+(Region=A2)>0),--((B2="")+(SVCCTR=B2)>0),--((C2="")+(Job_Category=C2)>0),--((D2="")+(Status=D2)>0))"
I have 60 total and 8 were termed so my formula should give me 52. But the above formula gives me 60. I have attached a sample for a better understanding. I am stumped in what the problem is. Can you please what is wrong?
Thanks in advance for your expert knowledge and help.
Michelle
Bookmarks