I am curious if there is a formula that will return the sum of all values that meet multiple criteria. I have attached an example and while I know that there are a couple of options using sumif() formulas with a single critera, I am looking for a solution where I can have an array or mutliple critera to return the sum of. The example attached should give you the general idea but my real life example has much more data so I could nont simpily string 5 sumif formulas together to return me desired outcome. Let me know if you have any suggestions or need further explaination of what I looking for.
Thank you,
Bookmarks