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?
iPad Air 4 Wi-Fi
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
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
Thank you! I was so confused and obviously still learning.
"SUMIF requires that all range arguments are the same size."
