In my workbook I have an excel sheet(called state_sum) with a some vlookups, arrays, and other basic formulas. The values on this sheet change based the state selected in cell A2.
I need to find a way of summing all of the values for a group for a region. For example the midwest - I would...