Multiple Countifs Using Symbols

SS_user10294507

I am not an advanced formula user. I want to find the count of records that have multiple criteria. The formula I'm using now returns a value of 3, but should be 9.

=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, <>"Low")

I have a symbol column in my Action Item page that uses the 3 priorities (High, Medium, Low). Of the 9 records, three priorities are "Medium" and the remaining 6 are blank "". I want the formula to return null (""), "Medium", and "High" counts summed together (9). Basically, I want to exclude records with "Low" priority, but using my formula it returns a value of 3, seemingly disregarding blank priority values.

Thanks in advance for any assistance you can provide in cleaning up my formula.

L_123

=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), OR(@cell <> "Low", @cell = ""

SS_user10294507

L_123, thank you for your response. I receive a "#INVALID OPERATION" error when using this formula. Do I need to use the {AI Priority} reference instead of @cell? I tried to replace @cell with {AI Priority}, but doesn't seem to work.

L_123

Yeah sorry, I cut out the reference....

=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, OR(@cell <> "Low", @cell = ""

SS_user10294507

L_123, This works great. Thank you kindly!!!