Here are some problems that our users have asked and received explanations on
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