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 ...
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.