COUNTIFS with multiple criteria

aoqodhs

Hello,

I am a newer Smartsheet user and am learning as I go. I have tried several times to use COUNTIFS functions to count specific criteria from 2 columns in my source sheet, but continue to get the UNPARSEABLE error. (I also tried COUNTIF, then CONTAINS, but could not get that to work either.

We are wanting to count how many "General Applicants" in the Provider Type column also have "Founded" in the Disposition column.

This is the most recent formula I have tried with no luck: =COUNTIFS({8.31.22_Data_ProjectRollup Range 2}, "General Applicant"), COUNTIFS({8.31.22_Data_ProjectRollup Range 3}, "Founded")

Thanks for any help/suggestions you can give me!

Mike TV

@aoqodhs

=COUNTIFS({8.31.22_Data_ProjectRollup Range 2}, "General Applicant", {8.31.22_Data_ProjectRollup Range 3}, "Founded")

Mike TV

@aoqodhs

=COUNTIFS({8.31.22_Data_ProjectRollup Range 2}, "General Applicant", {8.31.22_Data_ProjectRollup Range 3}, "Founded")

aoqodhs

Thank you, @Mike TV !!