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?
Jennifer, i generated small test file. Not sure i understood your first picture, based on second one:
Formula in H7 calculates number of positions for the market in J6 with status as in G10. Calculation is made on columns C:C (Market), D:D (PositionNeeded) and F:F (Status).
That's only to illustrate the formula.
File is attached
OK - I got it working. THANK YOU! That's what I tried initially but I must have had something off. :-)
Great!
