Dear
Kindly do advise what formula should I use it.
Example:
Question : What is the different between A5 to B8.
Raw data :
A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
B1,B2,B3,B4,B5,B6,B7,B8,B9,B10
C1,C2.C3,C4,C5,C6,C7,C8,C9,C10.
In Manual calculation, the answer is : 14.
A5 to A10 = 6
B1 to B8 = 8
Total : (6+8)=14.