Forum Discussion
=COUNTIF() Issue
Hi All, So for some reason i used to be able to use =COUNTIF() formula to compare 2 lots of data and count the number of times it matches. For some reason and i really dont have a clue why i ...
The #SPILL error occurs when the spill range for a spilled array formula is not blank.
https://support.microsoft.com/en-us/office/-spill-error-spill-range-isn-t-blank-182c7141-7ff5-4dc2-ba38-7a81b7bf51c7
- Sorry i forgot to mention that i have tried all the Excel help and i don't have any other data in that column to block it? it should just have a 1 or 0 in the cell next to it.
This is why i'm so confused, i never had this issue before and i'm doing it the exact same way but all of a sudden i now get this #SPILL error when nothing is in the way. So frustrating!
