[ll]

thanks so much - i drove myself crazy doing it different ways for a week

"ll" wrote:

I am trying to multiply 2 numbers across in a table. I don't know why I'm
having so much trouble. I have a table with 7 cells across. Cell 1 is text,
cell 2 is text, cell 3 is a number, cell 4 is text, cell 5 is a number, cell
6 is text and cell 7 should be the multiplication answer. In cell 7, I have
the formula: =PRODUCT(LEFT), which should calculate all the numbers across
and skip any text. It doesn't work. It will work if I omit 1 column
therefore having the 2 columns with the numbers next to each other. Any help
would be appreciated. Thanks, ll