Synatx Error

[Kristy Lee]

I am trying to Multiply the sum of two cells together. Every formula I try I get "Syntax Error" where the answer should be. I have no idea what I am doing wrong
I have even tried book markin
I am at a loss

 

[Kniery]

Kristy Lee
what formula are you putting in? your problem may lie there in.

 

[macropod]

Hi Kristy,

To multiply two cells, all you need is a field coded with the formula
=A1*B1, replacing A1 & B1 with whatever your column/row references are.

But you say you're trying to "Multiply the sum of two cells", which doesn't
make sense. Do you mean the sum of two columns? If so, the formula would be
=SUM(A:A)*SUM(B:B), again replacing A:A & B:B with whatever your column
references are. Note that you can't use such a formula in either of the
source columns - if you do you'll get a wrong result every time the field
recalculates.

Cheers

I am trying to Multiply the sum of two cells together. Every formula I try

I get "Syntax Error" where the answer should be. I have no idea what I am
doing wrong.