Forum Discussion
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...
Hi Jennifer,
For AND criteria you may use SUMIFS
=SUMIFS(PositionsNeed,Market,K16,Status,B8)
Thanks Sergei, but that didn't work. Where is that formula do you define the criteria . Just having a comma between everything doesn't say Market must = k16's value... , right?