Sheet summary formula help

Caitlin Bowman

Hello,

I'm hoping to get help on how to create a formula in my sheet summary. I have a sheet with a column of drop down selection for countries, and I have a column checked if unique tool. I am wanting to create summary fields for each country to know how many unique tools each country has. I have already created a summary field for unique tools, I just need to add in the country component. Could you please help me with this?

Thank you so much!

Caitlin

Caitlin Bowman

=COUNTIFS([Unique Tool]:[Unique Tool], 1, Country:Country, "Afghanistan")

Andrée Starå

Hi @Caitlin Bowman

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

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!

Caitlin Bowman

=COUNTIFS([Unique Tool]:[Unique Tool], 1, Country:Country, "Afghanistan")