On May 1, 3:27*am, Ram wrote:
I just want to know if any lookup value is repeating in range,which
function we should use at that time.
For ex

A * * * * * * * * * * * * * * B * * * * * * * * * * * * * * * * C
Name * * * * * * * * * * *Value
a * * * * * * * * * * * * * * *2623
b * * * * * * * * * * * * * * 2561
c * * * * * * * * * * * * * * 12546
d * * * * * * * * * * * * * * 4563
a * * * * * * * * * * * * * * *452
c * * * * * * * * * * * * * * *223321
d * * * * * * * * * * * * * * *321

With above example i want to know how can we *find each value for a in
lookup range A:A.
if is there any another nested function,please let me know

Regards
Ram

If you want to sum look in the help index for SUMIF. To count look for
COUNTIF