Hi,
Please would you be able to help with a formula.
I am trying to bring back the correct result as follows.
1 2 3 4 5 6 7 8 9 10 11 12
Consultancy 10000 10000 5000 6000 4000 5000 1000 2000 3000 2000 3000 5000
Travel 5000 1000 1000 2000 1000 3000 1000 1000 2000 1000 2000 3000
Training 1000 1000 500 1000 500 1000 500 1000 500 500 1000 500
Another table has my criteria of
Consultancy
Travel
Training
Cell A is 12
In the Consultancy cell in the second table I would like to bring back a sum of the columns that are equal to and less than Cell A.
If Cell A is 12 then the result is the sum of 1 to 12 = 56000
If Cell A is 1 then the result is the sum of 1 = 10000
If Cell A is 3 then the result is the sum of 1 to 3 = 25000
Many thanks in advance
Andrew
Please would you be able to help with a formula.
I am trying to bring back the correct result as follows.
1 2 3 4 5 6 7 8 9 10 11 12
Consultancy 10000 10000 5000 6000 4000 5000 1000 2000 3000 2000 3000 5000
Travel 5000 1000 1000 2000 1000 3000 1000 1000 2000 1000 2000 3000
Training 1000 1000 500 1000 500 1000 500 1000 500 500 1000 500
Another table has my criteria of
Consultancy
Travel
Training
Cell A is 12
In the Consultancy cell in the second table I would like to bring back a sum of the columns that are equal to and less than Cell A.
If Cell A is 12 then the result is the sum of 1 to 12 = 56000
If Cell A is 1 then the result is the sum of 1 = 10000
If Cell A is 3 then the result is the sum of 1 to 3 = 25000
Many thanks in advance
Andrew