I have a Countifs formula that is returning zero, I believe because some cell values are blank. If I back out the items that have blanks it works fine
=COUNTIFS([Area],[@Area],[Section '#],[@[Section '#]],[Item Description],[@[Item Description]],[L1],[@L1],[L2],[@L2],[W1],[@W1],[W2],[@W2])
Here is a snapshot of the table I am trying to use the formula in
How can I make this work when I have blanks?
Thanks,
Greg
=COUNTIFS([Area],[@Area],[Section '#],[@[Section '#]],[Item Description],[@[Item Description]],[L1],[@L1],[L2],[@L2],[W1],[@W1],[W2],[@W2])
Here is a snapshot of the table I am trying to use the formula in
How can I make this work when I have blanks?
Thanks,
Greg