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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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(D7:D33)
 
Back
Top