“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hello, I need help regarding indirect formula of excel. 1. What is the purpose of using this formula? 2. If we use this formula with sum formula, then why we are using this with sum formula, we can also perform addition from different sheets without indirect formula ?

Solved by O. D. in 25 mins

i want to use the value in two fields to generate a sum statement like the following. AE55 contains the start row and af55 contains the last row. the sum statement should read sum(g53:g55). =IF(AE55>0,SUM("G",INDIRECT(AE55),":G",INDIRECT(AF55),")"," "))

Solved by T. H. in 25 mins

Please help me understand the function. =IF(C$2+$A3<=60,SUM(INDIRECT(BM$2&ROW()&":"&CELL("address",OFFSET(C3,0,$A3-1)))),""). I don't get the SUM(INDIRECT(BM$2&ROW()&":"&CELL("address",OFFSET(C3,0,$A3-1)))) Part

Solved by O. A. in 21 mins

Excel help with offset/indirect functions

Solved by E. J. in 17 mins

=IF($C$127="",VLOOKUP(B127,INDIRECT($B$128),10,FALSE),INDEX(INDIRECT($B$128),MATCH(1,(INDIRECT($B$129)=$B$127)*(INDIRECT($B$130)=$C$127),0),10)) shows me #N/A

Solved by M. H. in 20 mins