Using AND with IF to check two text fields

James Raikes

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'")))

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.

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.