#SPILL Error

[AOmotayo]

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.

[#2]

@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-ef9c...

[#3]

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