Formula using sumifs and indirect function for worksheets. Getting Reference error although Had it working with different columns
Unusual, but this is working fine in my test scenario.
Use the Evaluate Formula tool to see where the error creeps in. You may have a typo in the list of tables.
