Ignoring blanks in Countifs

bpeters
bpeters ✭✭
edited 12/09/19 in Formulas and Functions

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. 

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!