Please hlep , I think this is easy for you.

[smash123]

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

[vikas.bhandari]

Though I didnt understand mch with the info u provided....please check if the attachment helps you...if not then give a Raw Data in an excel sheet so that we can work on them!!!

Thanks,
Vikas B

[chrysti]

I don't know if you actually need it to say apples=5 and orange=2 but this formula will get that exact result
=A1&"="&SUMIF($A$1:$B$3,A1,$B$1:$B$3)

if it doesn't then you can use the
=SUMIF($A$1:$B$3,A1,$B$1:$B$3)

this will put the total for each type in col C it will list the total beside every one though, if you don't want it to repeat there is a fix for that too, but off the top of my head I can't think of what it is.

HTH
Chrysti