Forum Discussion

Hookie110's avatar
Hookie110
Copper Contributor
Apr 21, 2021

=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 keep getting the #SPILL error instead?

 

I've tried Googling it and i cant seem to find the exact fix for this issue

 

do any of you gurus out there know a fix?

 

please let me know if i need to clarify anymore information in order for you to help!

 

Thank you!

 

Lewis

excel
Formulas and Functions

2 Replies

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Apr 21, 2021

    Hookie110 

    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

    • Hookie110's avatar
      Hookie110
      Copper Contributor
      Apr 21, 2021
      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!

Resources