#SPILL Error and Autofilling Formulas

Hi all,

So I'm currently running into an issue I've never had with Excel. I'm using Microsoft Excel for Mac Office Home & Student 2021.

I'm trying to get a frequency count of the different response options that students chose for a test, and when I try and do a frequency count, it auto-populates the cell right below it. I believe it's tied to a #SPILL error, or SPILL feature, and I've never had this issue until recently. Is there a way to prevent this from happening? I would only like cells E3 to H3 populated, but am kind of stumped.

I've included a screenshot as well as a workbook with the problematic cell (E4), which also becomes highlighted with a blue border when I select the non-problematic cell (E3). The reason for the screenshot is in case this problem doesn't show up on the attached workbook when viewed.

I'm not even able to delete the 8 cell E4. It seems like it's tied to E3. Just wondering if there's a way to prevent this.

Any guidance is greatly appreciated!
Screen Shot 2023-01-16 at 4.48.42 PM.png

As per the FREQUENCY documentation:

◾The number of elements in the returned array is one more than the number of elements in bins_array. The extra element in the returned array returns the count of any values above the highest interval. For example, when counting three ranges of values (intervals) that are entered into three cells, be sure to enter FREQUENCY into four cells for the results. The extra cell returns the number of values in data_array that are greater than the third interval value.

Clear the existing formulae and then try the formula:

Formula:

Please Login or Register  to view this content.

Thanks for the rep.