SumIF errors


I have a very simple formula in one of my sheets, eg:

=SUMIF(Type251:Type271, "Service", Value251:Value271)

and it works fine, the last row on the table is row 266.

however if I extend the formula to =SUMIF(Type251:Type281, "Service", Value251:Value281)

essentially just including more empty cells, I get an unparsable error.

Any ideas? It's driving me mad

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!