Data Example.xlsx

Hey All,

I'm trying to do a sum function for two criteria basically.

One being the project number (see excel) and the other being a few symbols in that project which compose an expense category.

For example I'd being looking for the total of all personnel costs (900 codes on spreadsheet) which are under project A. I'm hoping there is an easy way to do it where I can do an or and not like a sum(sumifs) for each of the project and symbol codes. something like sumifs(amount, project code, =A, symbol, =or(900,901,902) etc...

Thanks folks,

-Jake