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.

Thanks!

Screen Shot 2022-04-08 at 4.46.10 PM.png

Find more posts tagged with

Accepted answers

All comments

Paul H

You have a weird quotation mark in front of Answered

Smartsheet User 99

=COUNTIFS(Name:Name, "Fred", Result:Result, "Answered")

Earl P

I am doing something similar however for my name column it is a dropdown multi select column and it seems it only counts where they name is selected by itself. Does anyone know how to remedy this? Here is the formula for example:

=COUNTIFS({Training Project Task List Range 3}, "Aubrey Campbell", {Late Check}, @cell = "Late")

jal1172

I fixed the quote.. still not working...

Tried SmartSheetUser 99's format... still not working...

I will open a support request.

Thanks for the recommendations!

jal1172

Got it! My format was actually correct, one of the values I was working with had a -. I split the text to two columns and got it to work! That's what I get for tying to do formula's on a Friday afternoon! :-)

Smartsheet User 99

https://community.smartsheet.com/discussion/comment/325664#Comment_325664

Your formula is looking only for Aubrey Campbell by itself, what's the end game that you're looking for with this formula?

Mary Farmer

@Smartsheet User 99 I have a question on this example. How would you write the formula if they wanted to count "Answered" and "Call Forwarded" for "Fred"?

Thanks!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.