Sumifs with a list of criteria
<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>