Apr 13 2022 09:53 AM
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 and adding a new column after the total. I dont understand why this is a spill error. Please help! Thank you!
Apr 13 2022 10:22 AM - edited Apr 13 2022 10:23 AM
The result of the formula is 3 values. You have room for 2 numbers. The 3rd value is trying to go in the cell that has 95 so the result is a Spill error.
Apr 13 2022 10:25 AM
SolutionYou 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 )
Apr 13 2022 10:51 AM
@Sergei Baklan Thank you for your response! I guess i need to learn more about arrays.
Apr 13 2022 10:25 AM
SolutionYou 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 )