If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What is the formula for adding up *values! in a columm in exell
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 |
#2
|
|||
|
|||
What is the formula for adding up *values! in a columm in exell
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) -- David Biddulph "larry" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|