Forum Discussion
Milou
Dec 26, 2024Copper Contributor
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.
- Patrick2788Silver 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_EekelenPlatinum 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.
- MilouCopper 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?