office365 - Excel, how can i count values ?next to cells with the same name

Question

Imagine that we have this table enter image description here

How can i count apples ?

question from:https://stackoverflow.com/questions/66054896/excel-how-can-i-count-values-next-to-cells-with-the-same-name

Answer 1

I hope this will be useful to you

=SOMMEPROD((A2:A5="Apple")*(B2:B5))