Hi Mike

Sorry to bother you again. Can you see the problem with this formula? I
don't need to pick up a range of codes, I need a selection of different
codes, but from the same data as before. This is returning zero as the
answer. (Sorry it's long, but thought it was easier to send the whole thing!)

=+SUMPRODUCT((Actuals!A2:A630=5010111)*(Actuals!A2 :A630=5010211)*(Actuals!A2:A630=5120111)*(Actuals! A2:A630=5200111)*(Actuals!A2:A630=5200211)*(Actual s!A2:A630=5260111)*(Actuals!A2:A630=5260211)*(Actu als!A2:A630=5400111)*(Actuals!A2:A630=5400211)*(Ac tuals!A2:A630=5400311)*(Actuals!A2:A630=5401211)*( Actuals!A2:A630=5440111)*(Actuals!A2:A630=5480111) *(Actuals!A2:A630=5640111)*(Actuals!A2:A630=564021 1)*(Actuals!C2:C630))

Thanks again
Caroline

"Caroline" wrote:

Hi

I hope someone can help. I think I've solved this before, but cannot
remember for the life of me how to do it!

I have some data that I want to produce some summary figures from:

E.G
Col A Col B

1000 10
1001 20
1002 30
1003 40
1004 50
1005 60

What I want to do is do a vlookup for say 1001 to 1003 inclusive, giving the
result as the sum of the figures in Col B. In this example, the answer would
be 90. Also, would it be possible to miss numbers out, e.g getting the
results from 1000 and then 1003 to 1005? Hope that makes sense and thanks in
advance for your help.

Caroline