Sumif Unparseable if to many rows

Grant

So I have the following Sumif formula working and giving the proper result.

=SUMIF([Business Unit]891:[Business Unit]900, [Business Unit]868, [Implemented FY18 (CUR)]891:[Implemented FY18 (CUR)]900)

The problem is the range isn't big enough and if I extent the range to beyond 900 rows I get the Unparseable error message.

I haven't been able to figure out what is causing the problem and I need to add 300 rows to the range.

Paul Newcome

Can you post the exact formula that is giving you the error?

Grant

That is the formula copied directly from the cell. The formula is working but if I change the 900 rows to 1000 then I get the Unparseable message.

J. Craig Williams

Do the rows already exist? You have 1000 rows in the Sheet?

Craig