IF/Then across multiple columns

I am trying to quantify 2 values ( -1 and 1) across 5 columns into usable data. I am trying to have the end result produce a number 5 through 1 in a blank column.

So if I am thinking about this correctly then I should have

Please Login or Register  to view this content.

Which I translated to an Nested If of

Please Login or Register  to view this content.

All I am getting with the nested code is "False"

I am going to do another nested IF function to produce for the -1 and result in 1 through 5. Then I should be able to subtract the 2 values produced to get the information I am looking for.

Any help would be appreciated.

** EDIT **

Sorry I am working in Excel 2007 for this.

Should the "1" be in quotes? Try removing the quotes.

and/or you can try perhaps:

=5-MATCH(1,A2:E2,0)+1