Hi all, first time poster!
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
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