How would I go about setting up a scenario that counts similar items on google sheets? For example, i have a google sheet that states the following: Row 1= Banana Quantity= 1 Row 2= Banana Quantity= 1 Row 3= Apple Quantity= 1 I am looking to have it so that it counts each row that says “banana”…

Hi @wengthemeng Sample sheet: [image] Workflow: [image] You can group by fruits name and then get sum of quantities: [image] Output: [image] Best regards, Msquare Automation Gold Partner of Make @Msquare_Automation

How to Count Similar Rows in Google Sheets?

How To

Msquare_Automation September 5, 2024, 6:45am 2

Hi @wengthemeng
Sample sheet:

Workflow:

You can group by fruits name and then get sum of quantities:

Output:

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

2 Likes

Topic		Replies	Views
Comparing 2-4 rows in the Google Sheet Getting Started filters , arrays , google-sheets	3	702	January 16, 2024
Count new rows How To google-sheets	2	187	July 31, 2024
Count and Depend of the result make other step How To google-sheets	6	290	January 29, 2024
Retrieving number of rows on Google Sheets How To	3	1273	September 7, 2023
How to get unique data based on Google Sheets data How To	9	1525	September 22, 2023

How to Count Similar Rows in Google Sheets?

Related topics