What is the formula for adding up *values! in a columm in exell

[larry]

Hi, I am designing a chart that enables me to in one columm have a dollor
value and next columm have a percentage in it to give a total in the third
columm. The formula i use is =sum(b7*c7). When i press enter it reads in the
third columm
*VALUE!. I drag this all down the row so that the formula is
duplicated down the row , I then enter a formula in the last row to get a
subtotal =sumb7:b33. But it will not add, Can you please give me the formula
so it will add all the values. Thanks

 

[David Biddulph]

If in D7 you want to multiply B7 and C7 you don't need SUM, and the formula
can be just =B7*C7, but if your formula (including SUM) is giving a VALUE
error, then you've probably got text, rather than a number, in one or both
of your B7 and C7 cells.

If you want to add the cells from B7 to B33 inclusive, the formula is
=SUM(B7:B33)
[Remember the brackets]

Similarly if you want to total the products in column D, the formula is
=SUM(D733)