Formulas How to Set Excel Ranges with INDIRECT and SUMIFS Let’s explore how to set Excel ranges using the INDIRECT function. In this example, we will find and total specific items across multiple worksheets based on specified criteria. Functions Needed …