I have 2 columns, column A runs from 10 down to 1. Column B has some other figures in it.

I want a function where I can put a number in a cell and it will lookup in column A to find the number I put in, lets say it is 8 and then I want it to SUM the values in column B that are equal or higher than the value 8. So for example:

10 13

9 2

8 3

7 6

6 5

5 4

4 5

3 6

2 7

1 8

If I put the value 8 into a cell, I want the adjacent cell to sum up the values for 8,9 and 10 and display 18 in this case.

I had =VLOOKUP(A15,A1:B10,2) which gives me the value 3, but I'm not sure how to get the other values and add em up. I also want to be able to do a further mathmatical function on that number if possible (e.g. multiply the result by 0.7).

Any help pls?

Cheers

JOJ