Hi Raj

Try the below formula

A2:B10 is your data
F2:F4 is the range 2

=SUMPRODUCT(SUMIF(A2:A10,F2:F4,B2:B10))

If this post helps click Yes
---------------
Jacob Skaria


"Raj" wrote:

I want to sum a range based on another range of cells. I can detail my
problem as follows:

Range: 1
Name Points
A 1
B 2
C 3
D 4
E 5

Range: 2

Name
B
C
E


My intention is to sum the corresponding values of Range: 2 in Range: 1.

In another words to sum the values corresponding to B, C and E which would
be 10.

The main problem is the second range i.e. Range: 2 may change. I want to
have a solution for this.

Please send to my e-mail ID : if you can solve this.
Please, please and please help me.