I have 2 questions: Please help if you can.
Want to know what is the forumla for my case?

A B C
APPLE 3 APPLE=5
ORANGE 2 ORANGE=2
APPLE 2

I have data of column A and B. When A column is the same of a kind then add B and output the answer to C1. Thanks







Want to know what is the forumla for my case?

A B
APPLE APPLE=2
ORANGE ORANGE=1
APPLE

I have data of column A. When A column is the same of a kind then 1 and output the result to B1.
Thanks