sumifs using multiple criteria

I have a spreadsheet called Stats with named columns STATS (which holds status of either Open, On Hold, Closed - Loss....etc), MARKET (which holds location of either PHX, NYC, FL, etc.) and column ca...