title: Sumifs with a list of criteria
body: <p>I would like to have a sumifs formula where it refers to a list of possible variables ie different account numbers.  I would prefer to do it rather than hard code it as individuals can  </p>
  
  <p>So effectively doing a sumifs for each of the account codes and adding them together in one cell.  I know I could effectively add them up but was wondering if there was a more flexible approach.  As new accounts may get added etc.</p>
  
  <p>I could also do a total of each account separately and add the totals which would also work but would be more clunky.</p>