Get instant live expert help on indirect formula excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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
Excel help with offset/indirect functions
Solved by E. J. in 17 mins
Hi Can you assist, I am using a countif formula and want to include indirect to count the number of "P" between 2 dates. I have this formula working but cant seem to get to work using indirect as get #value I want to use indirect as I have several similar sheets and just want 1 summary page. Working formula not using indirect =COUNTIFS(Sample!6:6,">="&B5,Sample!6:6,"<="&C5,Sample!8:8,"="&I7) Non working formula using indirect =COUNTIF(INDIRECT("'"&$G$2&"'!"&$C6,">="&B5),(INDIRECT("'"&$G$2&"'!"&$C6,"<="&C5),(INDIRECT("'"&$G$2&"'!"&$C8),I$7))) G2=Sheetname which one is called sample C6=6:6 C8=8:8 B5=From date B6=To date I7=P Thanks Matt
Solved by G. U. in 25 mins
I want to understand this formula and see where the source data is coming from =IF(ISERROR(VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),3,0)-VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),2,0)),0,VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),3,0)-VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),2,0))
Solved by S. A. in 19 mins
Need help with indirect formula. Picture lookup method.
Solved by B. A. in 25 mins