#spill! error

i have attached an excel spreadsheet based on up todate MS Business Office

Migrate to R36C16 That cell should be have the text "Food" in it.

My problem is totally within the section of food from range R37C13:R40:C32

in column 18 you will see the cell error #spill!

If you go to "forumla" tab and select evaluate forumula, you will see that the evaluation of the formula does select the correct values but when it
does a division, the error surfaces.

I am baffled as to where the "overlap" is that the error refers to.

please help me.

Thank you for such a fast response.I have no idea what a merged cell is.
If i have a merged cell it was unintentional.

Please help me understand what it is and I will look for it in the future
if it appears again.

also.
how do i just "remove" it?

thank you once again.
bil

Oh Oh 0h. I looked up "merged" and suddenly understood.

I have been using merged cells forever.
so i am looking for a way to replace that option.

i often have individual numbers on the right and a sum of them
to their left. if i had an odd number of rows, I would just place
the sum in the middle row. if i have an even number of rows my sum
is not centered.

how do you address this issue

i can't find the option, "center across selection" under cells->format

oh...just read you message again.

i am so sorry.

your answer was so so complete.

thank you again.

Thank you for being patient.

I definitely saw the center across selection in the horizontal selection.
BUT
center across selection is not in the vertical selection. My problem is occuring when I attempt to merge vertically, not horizontally
i will try it anyway...

the calculation math does work with center across selection,but the value is placed in the upper most cell of the four rows.

at least i am half way there.

now to find a way to emulate center across vertical selection.
bil

ok,,,,I tried the buttons.....but they just moved the correct calculation around within the cell.

I sent you a picture of what i see.