My formula to count the number of employees just based on date seems to work but if I use multiple criteria I get an incorrect number - see highlighted cell in sheet titled Calculations(2).
I need to calculate based on Active status, hourly or salary and before the date in Col A of sheet titled Calculations(2)
I am trying to add up total compensation based on the same parameters of Active status, Function (col A) and whether salary or hourly. I am able to get the sum if all data is included (whether active or not) but not if I include any additional parameters.
Thanks in advance,
USurrao
The formula should be:
=COUNTIFS('Employee Data'!$C$3:$C$20,"<"&A3,'Employee Data'!$I$3:$I$20,"=Active",'Employee Data'!$M$3:$M$20,"=Hourly")
Thanks a million, it worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks