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
Help Article Resources
Check out the Formula Handbook template!