I've created a table with several coloumns and rows and would like to use the formula coloumn B / coloumn C in coloumn M. It works with single cells of coloumn M but cannot find solution for the whole coloumn.
MacBook, OS X El Capitan (10.11.6)
kytaku wrote:
I need B/C in each row of M, that's all. Is it possible wothout SUM?
Sure. Enter =B/C in M2. Then drag the yellow dot down to fill into the other rows of M.
(You could also enter =B2/C2 in M2 and the formula will automatically adjust as you fill it down the column by dragging the yellow dot.)
SG
kytaku wrote:
I need B/C in each row of M, that's all. Is it possible wothout SUM?
Sure. Enter =B/C in M2. Then drag the yellow dot down to fill into the other rows of M.
(You could also enter =B2/C2 in M2 and the formula will automatically adjust as you fill it down the column by dragging the yellow dot.)
SG
Is this what you're looking for?
Row 5 is defined as a Footer Row.
The formula in B5 is =SUM(B).
The formula in C5 is =SUM(C)
The formula in M5 is =B/C.
You could also use the formula =SUM(B)/SUM(C) in a cell.
SG
...and there's really a yellow dot! Your help saves me time! Fantastic! Thank you!!!
If you have energy for my next question... I need the equation of my chart to generate data in a new table. How can I copy or transfer it as a formula?
Thanks for the green tick!
If you have a question about charts, perhaps you could start a new thread. And if you can, I suggest posting more specifics, perhaps a screenshot, so it will be clearer what you are trying to do.
SG
Thank you! With the equation I'd like to generate further 'P%' for more row 2 or 'Absorbance' data. I've created a new table for that so that data like in row 2 here is put in coloumn B and want to get results in C with a formula similar to that of the chart. There must be a more 'intelligent' way than typing it in the cell's formula frame. How can I 'export' that?
Thanks for your time! Yes, without the footer row! I need B/C in each row of M, that's all. Is it possible wothout SUM?
The equation could look like this in a cell.
=0,028×B2^2−0,0194×B2+0,0119
SG
Thank you!
Formula for coloumn
