Forum Discussion
Solved
Spill error
Hello, I am trying to do the following basic formula and keep getting spill error. I am just trying to add the 3 columns and subtract them from the total. I tried it by deleting the empty column a...
You formula returns an array like this
If you put formula in F2 there is not enough space to place such array, thus #SPILL! error.
Perhaps you mean
=G2-SUM( B2:D3 )
You formula returns an array like this
If you put formula in F2 there is not enough space to place such array, thus #SPILL! error.
Perhaps you mean
=G2-SUM( B2:D3 )
SergeiBaklan Thank you for your response! I guess i need to learn more about arrays.