Hi,

Just a quick one - I've just imported my excel sheet into google sheets - some of the large formulas aren't working as they previously have. Is there a reason why?

Are there any quick fixes?

I'm using a lot of sumifs - + the formulas now have "=ARRAY_CONSTRAIN(ARRAYFORMULA(SUM(SUMIFS" (bold part is the start of the formula in an excel sheet, the other array part has been included when I imported it.

Let me know,

Z