“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

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