SOLVED

Spill error

Copper Contributor

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!

maryellenc620_0-1649868399785.png

 

3 Replies

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.

best response confirmed by Grahmfs13 (Microsoft)
Solution

@maryellenc620 

You formula returns an array like this

image.png

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 )

@Sergei Baklan Thank you for your response!  I guess i need to learn more about arrays.  

1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@maryellenc620 

You formula returns an array like this

image.png

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 )

View solution in original post