Forum Discussion

Milou's avatar
Milou
Copper Contributor
Dec 26, 2024

Excel formula troubleshooting

Hi everyone. I am using excel online to try and become a data analyst. now I have troubles with the formulas. I am doing what is supposed to work. " =sum or subtotal (I2:I38) and press enter but the end result is overflow. what is going wrong here?

Help would be very welcome.

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    If I'm not mistaken, some languages show #OVERFLOW! instead of #SPILL! when neighboring cells are occupied and there's no room for the results of a dynamic array.  However, SUM/SUBTOTAL's results should be a scalar with no spilling. It may depend on the context of where you're using it. A sample would be helpful.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    What do you mean by "there end result is overflow"?

    =SUM(I2:I38) should return the sum of the numeric cells in the range referenced.

    SUBTOTAL expects a number as the first argument that indicates which aggregation (average, sum, count etc.) you want and the range to apply it to as the second argument.

    =SUBTOTAL(9, I2:I38) would return as the SUM formula above.

    • Milou's avatar
      Milou
      Copper Contributor

      hi. thank you for your reply. well, overflow is gone but no matter how much I try, it either ends with zero or name.....

      and I have tried =sum(i2:i38) but it does not seem to work. I even put it in numbers instead of text but no luck at all.... does excel still work with windows 10?

Resources