Forum Discussion
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 ...
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.
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?
