I am trying to build a COUNTIF statement in Excel 2010 using a total of 4 sets of criteria. I would ideally like it to look something like this:
COUNTIFS(range1,value in a1,range2,value in b1,range3,value in c1,range4,value in d1)
This works fine if there are actual values in cells A1-D1. however, if one of those cells is blank, I don't get the number back that I would expect. (I am testing this by autofiltering using the criteria I'm setting in A1-D1). What DOES seem to be happening is that if C1 is blank, then the COUNTIFS returns a count of all rows where C1 is not blank.
Is there a way to set a default so that if there is no value in A1-D1, COUNTIFS includes everything?