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”?
Essentially what I’d like the output to be is:
Banana= 2
Apple =1
