Excell Script/Problem

[swanley007]

I would like to write a script that compares two columns call them A and B

If column A is greater than 0 AND column B is greater than 0 then add A to a running total.

If either column is blank or 0 do not add anything to the total.  Also the columns are in another sheet.

I want this total to be displayed in one cell.

Thanks

[qinghao]

can you give us a sample structure of you excel workbook?