COUNTIFS - Referencing a Table with Multiple Criteria

[mediatrap]

Hello!

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

 

[mediatrap]

=COUNTIFS($A$1:$A$5,"SOD",$C$1:$C$5,"Exempt/Profile")

Or, if the range is converted into an Excel table:

=COUNTIFS(Table2[Region/Section],"SOD",Table2[Exempt/Profile],"Exempt/Profile")

It works! Thank you so much. I see now that I was over-complicating it.

 

[Aladin Akyurek]

It works! Thank you so much. I see now that I was over-complicating it.

You are welcome. Thanks for providing feedback.