countifs returns zero when a cell is blank

[gberg]

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

 

[Fluff]

If the values are text & not numbers you could use

=COUNTIFS([Area],[@Area],[Section '#],[@[Section '#]],[Item Description],[@[Item Description]],[L1],[@L1],[L2],[@L2]&"",[W1],[@W1]&"",[W2],[@W2]&"")

 

[gberg]

That worked perfectly! You are awesome Fluff!!!!!!!

Thanks for your help

Greg

 

[Fluff]

Glad to help & thanks for the feedback.