FormCalc script won't work in LiveCycle Designer

Hi,

I am trying to write a script in LiveCycle Designer and it is not working.  I need help please.

I have a table with columns and rows that sum.  That part is working fine.  I wrote the following script and the column is adding but not doing any of the rest of it.  I am trying to get one box to sum except when it matches a sum in another box.  When it matches that sum I need the sum to change to the word “Clear.”  Here is my script:

if (Row9.Cell21.rawValue == "Row8.Cell19") then
Row9.Cell21 = "CLEAR"
else
Row9.Cell21 = Sum(Row1.Cell21 + Row2.Cell21 + Row3.Cell21 + Row4.Cell21 + Row5.Cell21 + Row6.Cell21 + Row7.Cell21)
endif
 

The row and cell title/numbers are correct and they do sum as supposed to.

I would really appreciate any help.  I have it set to Show: Calculate and Language: FormCalc the Run at: Client.