Sum/if/left formula help

[MJLG85]

Hello,

I had this produced for me a week ago or so, but it has stopped working and i am not sure whether it is the forumla or excel itself.

It is checking column A and finding the first 2 numbers of that cell, and if it matches what is in G, then is making a total of the sum in Column N.

=SUM(IF(LEFT('Paste Data'!$A$2:$A$4793,2)=$G26&"0",('Paste Data'!$N$2:$N$4793)))

When I set it up it seemed to work fine but now just doesn't do it anymore

Help?

 

[steve the fish]

Enter it CTRL-SHIFT-ENTER rather than just ENTER. Look for these {} around the formula in the formula bar.

 

[MJLG85]

That is in the formula bar as well, i just forgot to type it in here

 

[steve the fish]

Ok so what does not working mean? What does happen? Error?

 

[MJLG85]

I mean all it is doing is returning 0 despite the data being there on the paste data section

 

[steve the fish]

Then either you are not entering CTRL-SHIFT-ENTER, the numbers in 'Paste Data'!$N$2:$N$4793 are text or the answer is indeed 0.