Not able to get this to work, not sure if my brain is just fried since it is "Fri-day" ;-)
I am trying to get a count using columns F & K
Column F has product colors
Column K has Quantities
I want the formula to count colors based on a set criteria that have qty associated and ignore blank cells.
=COUNTIFS($F:$F,"Red and White",$F:$F,Yellow,$F:$F,Gray,K:K,"")
Thanks much in advance!
Bookmarks