formula help - sum if blank
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
Check out the Formula Handbook template!