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

Need help wtih data retrieval using offset and indirect

Solved by E. E. in 18 mins

Can not find #REF error start in my Google sheets when using Indirect Concatnate :(

Solved by K. L. in 28 mins

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

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

Could you please explain what is being referenced in the follow string? I am familiar with using INDIRECT and CONCATENATE together. =INDIRECT(CONCATENATE("'Sheet Name'!",K$1&$A6))

Solved by B. L. in 24 mins