What formula is best suitable for counting Yes and No and referencing column "Assigned To"

JimmyLarimer

What formula is best suitable for counting Yes and No and referencing the column "Assigned To" name i.e Brandon = 6 "Yes" Cathy = 1 "Yes", Jimmy = 1 "No" and 6 "Yes"

Paul Newcome

There it is. Your second [%Complete] is missing the space in the column name.

Paul Newcome

What exactly is your end goal for these counts? If you are wanting to show them in a chart on a dashboard, you can use a row report and skip the formula entirely.

Otherwise one example of a formula would be a COUNTIFS.

=COUNTIFS(range 1, criteria 1, range 2, criteria 2)

JimmyLarimer

Paul, not using in a chart or dashboard. Sole purpose is to count the # of Yes's for each PM to get a % of completion to tasks assigned as seen below - I got the Tasks Complete via a report, trying to simplify with the actual project worksheet as the report will not allow more than 1 column condition within filters.

Paul Newcome

I'm not sure I understand what you mean about the report filters, but the formula to use would be a COUNTIFS. Syntax for that is in my last comment.

JimmyLarimer

Here is the COUNTIFS formula I am trying and it keeps coming back #UNPARSEABLE

=COUNTIFS([% Complete]:[%Complete], "Yes", {Assigned To}:{Assigned To}, HAS(@cell, "Jimmy Larimer"))

Paul Newcome

Is your formula on the same sheet as the source data or a different sheet?

Same sheet ranges:

[Column Name]:[Column Name]

Cross sheet ranges:

{Range Name}

JimmyLarimer

Same sheet ranges:

[Column Name]:[Column Name]

=COUNTIFS([% Complete]:[%Complete], "Yes", [Assigned To]:[Assigned To], HAS(@cell, "Jimmy Larimer"))

Paul Newcome

Ok. And is the above not working?

JimmyLarimer

it is not - it is coming back as #UNPARSEABLE

Paul Newcome

I don't see any immediate syntax issues. Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?

JimmyLarimer

Screenshot of formula -

Criteria using in the same sheet

Does it matter that % Complete column has a fx in it?

Paul Newcome

There it is. Your second [%Complete] is missing the space in the column name.

JimmyLarimer

Paul thank you so much!

Paul Newcome

Happy to help. 👍️