Sumif Unparseable if to many rows

08/22/18 Edited 12/09/19

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.

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

    thinkspi.com

  • 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 WilliamsJ. Craig Williams Top Contributor

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

    Craig

Sign In or Register to comment.