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

Find more posts tagged with

Accepted answers

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).

All comments

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

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,

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.