formula help - sum if blank

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

I'm trying to run a formula to sum the numbers in a netdays row if another column is blank and am running into issues. 

Here is the formula that I have: 

=SUMIFS([Requested - Complete]81:[Requested - Complete]452, Q81:Q452, "1", [Survey Required]81:[Survey Required]452, "")

Any help on what I am missing would be appreciated. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!