Assume A1 to A10 have value of 11 12 13 14 15 16 17 18 19 & 20
and B1 to B10 have value of 9 8 7 6 5 4 3 2 1 0
Need formula or VBA - while giving reference cell value, it should be to count respective downwards cell value.
If i give A4 as 14 And A9 as 19, formula to be count B4 to B9 (6,5,4,3,2,1) = 21
and B1 to B10 have value of 9 8 7 6 5 4 3 2 1 0
Need formula or VBA - while giving reference cell value, it should be to count respective downwards cell value.
If i give A4 as 14 And A9 as 19, formula to be count B4 to B9 (6,5,4,3,2,1) = 21