Using AND with IF to check two text fields

Hi All,

I am trying to create a formula in a sheet that references a range from another sheet to work out IF 2 text conditions are true but not sure of the syntax. Can I get some help please with my attempt below;

Range 1 is a single select drop down using text

Range 2 is a single select drop down using numbers 0-10

I want to count the number of rows where "Account Creation" is selected with a Score of "10"

=COUNTIF((AND({Sales_Backlog_Snapshot_2402 Range 1} "Account Creation", {Sales_Backlog_Snapshot_2402 Range 2} "10'")))

Find more posts tagged with

Formulas

Accepted answers

BullandKhmer

Hi there,

Let me know if the below works for you.

=COUNTIFS(Sales_Backlog_Snapshot_2402 Range 1, ="Account Creation", Sales_Backlog_Snapshot_2402 Range 2, ="10")

Regards,

Adam.

All comments

Jason Duryea

=COUNTIFS({Sales_Backlog_Snapshot_2402 Range 1}, "Account Creation", {Sales_Backlog_Snapshot_2402 Range 2}, “10”)

Not sure the 10 needs to be in quotes or not with the drop down column. You can try with or without to see which works.

BullandKhmer

Hi there,

Let me know if the below works for you.

=COUNTIFS(Sales_Backlog_Snapshot_2402 Range 1, ="Account Creation", Sales_Backlog_Snapshot_2402 Range 2, ="10")

Regards,

Adam.

James Raikes

Thank you really helped did not see the COUNTIFS function.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.