You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

"SUMIF requires that all range arguments are the same size."

I imported a spreadsheet from Google Docs to Numbers and it’s a little messy. The formulas are the same on both documents and seem to match up. Any idea how to fix?


  1. This issue applies to all 4; Suntrust, Discover, Chase, Medical
  2. There’s a 2nd issue with the next cell over as well.

iPad Air 4 Wi-Fi

Posted on Feb 19, 2023 6:45 PM

Reply
Question marked as Top-ranking reply

Posted on Feb 19, 2023 7:04 PM

The first formula has a typo in the first range. It should be C3:C38 not C3:D38. Personally I would change it to C$3:C$38 and the second range to D$3:D$38 so that you can drag down with the formula to do the other three rows that have the same error


The error message for the second formula speaks for itself. The formula is summing 4 error triangles. When you fix the first formula (all four instances of it), this one should work



2 replies
Question marked as Top-ranking reply

Feb 19, 2023 7:04 PM in response to domi2times

The first formula has a typo in the first range. It should be C3:C38 not C3:D38. Personally I would change it to C$3:C$38 and the second range to D$3:D$38 so that you can drag down with the formula to do the other three rows that have the same error


The error message for the second formula speaks for itself. The formula is summing 4 error triangles. When you fix the first formula (all four instances of it), this one should work



"SUMIF requires that all range arguments are the same size."

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.