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

I need help on how to use indirect function along with sumifs function in excel.

Solved by Z. W. in 15 mins

=INDIRECT(B5&"[Item]") how to add subsititute formula in this section.

Solved by T. Y. in 29 mins

=SUMIFS(INDIRECT("$C"&$F1):INDIRECT("$C"&$F2),INDIRECT("$C"&$F1):INDIRECT("$C"&$F2),E$3). E$3 contains a specific condition of greater than only. How can this be changed to a range condition of less than and greater than.

Solved by K. D. in 16 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

Excel help with offset/indirect functions

Solved by E. J. in 17 mins