Count IF w/ Multiple Criteria


What should be so simple is turning into a nightmare...

I have a "Source" Sheet.

In that Source Sheet, I have multiple columns. (example below).

What I want is a COUNT of how many rows have "Fred" in the Name column AND "Answered" in the Result column. - so looking at my screenshot, my result here would be 2.

I have tried every COUNTIF formula that I could find, and I either get an erroneous result or an error.

Here is an example of one I tried, I get an #unparseable error, however I got the format from this site.

=COUNTIFS([Name]:[Name], "Fred", [Result]:[Result], “Answered")

Any help would be greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!