Ignoring blanks in Countifs
I am trying to create a formula to look at multiple columns and count if they meet a specific criteria. I have a formula that works when there is data in the sheet but it causes an error whenever data is missing. I need to create a template that can be used to create several trackers so I need the formula to work when there is data missing from some of the rows.
The formula is:
=COUNTIFS([Graduation Date]303:[Graduation Date]308, YEAR(@cell) = 2018, Complete303:Complete308, 1, [EVS/DS]303:[EVS/DS]308, "EVS", State303:State308,"MD")
The moment I extended any range to look from row 303 to row 1600, I get an invalid data type error. I need the formula to work even when there are blank rows because they will have data in them at some point.
Not sure if I am articulating this properly but if anyone can help I would greatly appreciate it.