Can COUNTIFS count on a column with values returned from a fomula?

This seems so easy, so I'm sure I'm doing something really dumb that I just can't see, but I can't get this COUNTIFS formula to work. It keeps returning "#NO MATCH" when I know that there is a match. I'm trying to count the number of times "EOX" appears in the Company column and "Reviewed with CSR" appears in the Supervisor Review column. The values in the Company column are returned based on an INDEX/MATCH formula and the Supervisor Review column is a Single-Select column. Could the column types be preventing the formula from working or am I just missing something really obvious?

Thanks for any help you can give!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!