I named an entire row as Gross profit and the next row as SG&A to calculate EBITDA, but it is showing #Spill! error even though I named both rows correctly with same range.

AOmotayo I don't think it has anything to do with naming. https://support.microsoft.com/en-us/office/how-to-correct-a-spill-error-ffe0f555-b479-4a17-a6e2-ef9cc9ad4023

Thanks for commenting. I have read this and still couldn't figure out what I did wrongly

Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

AOmotayo

Copper Contributor

Sep 17, 2022

#SPILL Error

I named an entire row as Gross profit and the next row as SG&A to calculate EBITDA, but it is showing #Spill! error even though I named both rows correctly with same range.

excel

Detlef_Lewin
Silver Contributor
Sep 17, 2022
AOmotayo
I don't think it has anything to do with naming.

https://support.microsoft.com/en-us/office/how-to-correct-a-spill-error-ffe0f555-b479-4a17-a6e2-ef9cc9ad4023
- AOmotayo
  Copper Contributor
  Sep 17, 2022
  Thanks for commenting. I have read this and still couldn't figure out what I did wrongly

Forum Discussion

#SPILL Error

Share

Resources