Indirect explanation

Sir

Find here an attached xls file and tell me plz what indirect formula will do here

and can u tell me how can i use indirect formula in a sheet plz

INDIRECT function convert text into cell reference.

in your sheet you have given =SUM(INDIRECT("e"&A1&":E"&A2)) where A1 is 10 and A2 is 5
the formula evaluation will be =SUM(E10:E5) which is same as =SUM(E5:E10)