Countifs now triggers a #SPILL! error

[raven_squire]

Hello,

I am using the below formula in a table.

=IF(COUNTIFS(GIS_Points!F3:F742,[Display],GIS_Points!E3:E742,[Location Code])>1,"True","False")

I have successfully used this formula in this way in tables in the past. Today excel is generating a #Spill! error.
A quick google revels that there is a new spill formula that outputs to an undefined amount of rows below the formula. This new spill formula apparently is not compatible with tables.
This is all well and good but I am not using a spill formula an countifs only returns on result.

Does anyone know what is happening?

Thanks

 

[raven_squire]

Ok, I solved this one.
I did not put an @ in from of the cell I was referencing. It should have been
=IF(COUNTIFS(GIS_Points!F3:F742,[@Display],GIS_Points!E3:E742,[@Location Code])>1,"True","False")

 

[rhybeka]

Hi Raven! Just curious - why is that @ symbol required?? I'm having some new #Spill! errors myself and figured somethings changed.

 

[Fluff]

It's to do with the new dynamic array functions, have a look here
Implicit intersection operator: @

 

[rhybeka]

ah - thank you much Fluff! I've been digging for info but it's been slow going :\

 

[Fluff]

You're welcome & thanks for the feedback