Which count formula do I use?

Kimbh

Hi, I have two sheets. The first sheet changes daily the words passed or failed depending if the item passed or failed our process. On the second sheet I need a daily count of how many items pass and how many items failed. This sheet needs to updated daily depending on how many passed or failed their are.

I've been reading the help docs but what count formual to use. Any advice?

Thanks

Paul Newcome

Are you able to provide screenshots for reference?

Kimbh

Hi, here is a screenshot of a what a sheet would look like. If I could count that Name 1 has three pass and 2 fail. Name 2 has 3 pass and 1 fail. This would update as the sheet updated. Thank you

Paul Newcome

You would need a COUNTIFS.

=COUNTIFS({Sheet 1 Name Column}, @cell = "Name 1", {Sheet 1 Status Column}, @cell = "PASS")

Just change the criteria to fit which count you are wanting to output.

Kimbh

Hi, I decided to try and count from one sheet to another. I used

=COUNTIF({Master Range 1}, @cell = "Name 1", +COUNTIF({Master Range 2}, @cell = "PASS")) but it gives me #Incorrect Argument set. What am I doing wrong?

Thank you for your time

Paul Newcome

@Kimbh Your syntax is incorrect. Please try using the syntax in my previous comment.

Kimbh

@Paul Newcome I will, I think I miss understood the first post you sent but I works now. When I do it live, the Name 1 sheet column is a pull down window. Can that cause the formula not to work?

Thank