If you want to count how many times "apples" pops out on the list, you have to use this formula:

=countif(A2:A5, "apples")

There you'll be able to know how many apples there are, but if you want to know the total of the 2 numbers associated with "apples", we have"

=SUMIF(A2:B5,"apple",B2:B5)

There, you will find that there are 118 apples. By the way, I learned this from this website. You can check this out to learn more about sumif: https://www.efinancialmodels.com/kno...tion-in-excel/


Hope this helps