need to find values

Rakesh Lavishetty

here i have the data with few country names with status as pass , fail and on hold. attaching screenshots below.

i need to figure out the values with the help of country names

EX; AMERICAS = Pass (no of counts), Failed (no of counts)

India = Pass (no of counts),Failed (no of counts)

plz suggest me how to achieve this.

newsheet.jpg

Status1.jpg

Andrée Starå

Hi @Rakesh Lavishetty

I hope you're well and safe!

Try something like this and continue the pattern. (replace the column names with yours)

Try something like this.

=COUNTIFS([Region Results]:[Region Results]; Region@row; Status:Status; "Pass")

The same version but with the below changes for convenience.

=COUNTIFS([Region Results]:[Region Results], Region@row, Status:Status, "Pass")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sing C

Hi @Rakesh Lavishetty,

If I'm understanding you correctly you want to find out how many instances of pass, fail, and on hold there are for each country. You could try creating a report on your sheet and grouping by country, then by status, then summarise by the 'Count' field, like this (with group and summary criteria below).

Andrée Starå

Hi @Rakesh Lavishetty

I hope you're well and safe!

Try something like this and continue the pattern. (replace the column names with yours)

Try something like this.

=COUNTIFS([Region Results]:[Region Results]; Region@row; Status:Status; "Pass")

The same version but with the below changes for convenience.

=COUNTIFS([Region Results]:[Region Results], Region@row, Status:Status, "Pass")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Rakesh Lavishetty

Hi @Andrée Starå ,

hope you are doing well.

thank you for taking your time to writing me.

the formula you have suggested working partially , could you please suggest me with any other so that it can give me accurate output.

Thanks,

Rakesh

Sing C

Hi @Rakesh Lavishetty,

If I'm understanding you correctly you want to find out how many instances of pass, fail, and on hold there are for each country. You could try creating a report on your sheet and grouping by country, then by status, then summarise by the 'Count' field, like this (with group and summary criteria below).

Andrée Starå

@Rakesh Lavishetty

You're more than welcome!

If Sing's excellent advice/answer doesn't work.

What isn't working?

Rakesh Lavishetty

Hi @Sing Chen ,

Thanks for your time in writing to me.

the suggested screenshots using report will use in future purpose.

In my current scenario I have modified @Andrée Starå suggested formula and got accurate output.

Thanks to both @Andrée Starå and @Sing Chen.

Hope will get support like this in future as well!!!

Regards,

Rakesh.