Here is the formula I have written. Obviously it does not work. I would
sure appreciate any assistance I can get in making it a valid formula.
PLEASE!!!!!

=Sum(IF('Worksheet2'!A1:A10=(Cell("contents",A474+ 1)),'Worksheet2'!J1:J8))

My attempt? To create a formula which
references the next cell AFTER this formula (A474+1)
takes the contents of that cell (Cell("contents", )
asks if the contents of that cell are the same as the contents of ANY
cell in
another Worksheet IF(Worksheet2'A1:A10=
If it does then SUM the contents of another range of cells
,('Worksheet2!J1:J8)

What am I not getting right?

Please Help