Formula

ejacksonBPT

What is wrong with my formula?
Looking to calculate how many new circuits and how many disconnects are in each of my 4 options.

Metric Sheet:

Proj Plan :

Paul Newcome

You need a COUNTIFS instead and it would look more like this:

=COUNTIFS({Status}, @cell = [Primary Column]@row, {Objective}, @cell = "New Circuit")

or

=COUNTIFS({Status}, @cell = [Primary Column]@row, {Objective}, @cell = [Primary Column]1)

Michelle Choate 2

=COUNTIF( {Order Tracker Template Range 2}, HAS([Primary Column]@row, [Primary Column]:1))

Also as an aside - Best practice for references pulled from other sheets is to always name them, rather then letting them be "Sheet Name Range 2". That way we can help you trouble shoot if your range is wrong. So something for Column 3 would be:

=COUNTIF({Order Tracker Objective}, [Primary Column}@row) would return the number of times the word in the Primary Column shows up in the Object Column in your Order Tracker Template.

Paul Newcome

You need a COUNTIFS instead and it would look more like this:

=COUNTIFS({Status}, @cell = [Primary Column]@row, {Objective}, @cell = "New Circuit")

or

=COUNTIFS({Status}, @cell = [Primary Column]@row, {Objective}, @cell = [Primary Column]1)

Michelle Choate 2

=COUNTIF( {Order Tracker Template Range 2}, HAS([Primary Column]@row, [Primary Column]:1))

Also as an aside - Best practice for references pulled from other sheets is to always name them, rather then letting them be "Sheet Name Range 2". That way we can help you trouble shoot if your range is wrong. So something for Column 3 would be:

=COUNTIF({Order Tracker Objective}, [Primary Column}@row) would return the number of times the word in the Primary Column shows up in the Object Column in your Order Tracker Template.