title: Alternatives to having multiple SUMIF formulas without requiring the user to apply a filter
body: <p>Suppose in your workbook:
  Sheet1 has a table with 20 columns and approx 1000 rows. Each row belongs to one of 50 categories. The developer cannot make any visible changes to Sheet1.</p>
  
  <p>Sheet2 has a cell where the user can enter an category ID, and is shown the result of a SUMIF on each of Sheet 1's columns. </p>
  
  <p>My understanding is that Excel will iterate through all 1000 columns for each SUMIF, performing the same search 20 times. Is there an alternative to this?</p>