COUNTIFS - Referencing a Table with Multiple Criteria/Conditions

[MediaTrap]

First of all, I'd like to thank everyone here for the advice and tutorials. They have helped me on many occasions.

Second, I want anyone reading this to know that I'm a super Excel newbie and don't really understand the program completely (Yet).

I work in a personnel office and need a spreadsheet to track specific individual data. I'm mostly using the COUNTIFS formula as it allows multiple criteria to be referenced against.

Here is the first formula that is working as it was intended:

=COUNTIFS(Everyone3[[#All],[Region/Section]],"SOD",Everyone3[[#All],[Urinalysis_Date]],"<"&CategoryLists!R2C10)

Part 1
Everyone3 is the table (range), Region/Section is the column of said table, "SOD" is the text inside to count
Part 2
Everyone3 is the table (range), Urinalysis_Date is the column of said table, "<" references to a date on a category list on another sheet

The PREVIOUS formula works as intended, but I cannot get THIS one to work:

=COUNTIFS(Everyone3[[#All],[Region/Section]],”SOD”,Everyone3[[#All],[Exempt/Profile]],”=Exempt/Profile”)

I know that something is wrong, I have theories as to what it is, but nothing seems to work. Any ideas?

Thanks for the time!




V/r,

MediaTrap

[dilipandey]

HI Media Trap,

welcome to the forum.

Please share a sample workbook along with your expected results. thanks.


Regards,
DILIPandey
<click on below * if this helps>