Same formula works in one cell but not another....

[kevintarr131]

Hi everyone,

Wonder if anyone can help. I have the below formula which works fine.

=SUM(IF(YEAR('Fixtures & Fittings'!$G3:$G65536)=INDEX!D$17,'Fixtures & Fittings'!$I3:$I65536,0))

However if I copy the formula into another cell it doesn't work? It is exactly the same formula but doesn't work. Any ideas?

The only thing I can see that is different is for some reason the cell in which the formula works in starts with curly braces { and ends with curly braces } as well. However when I edit the formula it removes the curly braces and then the formula doesn't work. Then the formula wont work in either cell.

I hope I've made myself clear. Any help is appreciated.

Thanks

 

[VoG]

Click in the formula bar then press CTRL + Shift + Enter.

It is an array formula Array Formulas

 

[ramananhrm]

Pls dont use just enter of ctrl+enter

An array forumla always requires Ctrl+Shift+Enter

 

[kevintarr131]

Ahhhh I see, thanks very much guys, really appreciate it. I'll have a read of Array Formulas.