The real Horizontal Formula question
 

Hi again,

OK, here is another try, same thing. We know in adding numbers in a
vertical fashion, the formula covers a range of cells (=SUM(A1:A30)
-- that's a vertical stack of numbers.

A horizontal example: I want to multiply whatever the number is
in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want
it
set up so that, like, in A1thru A30, the Col A number gets
multiplied by 7 and that figure shows up next to it in column B. So
it's multiplying across.

B1 = A1 x 7.
B2 = A2 x 7 etc.

Is there a formula for that and where does it go? It seems to me I
would have to enter the formula each time. Am I right or wrong?

The real Horizontal Formula question
 

See my response in your other thread. Repeat the essence he
In B1 put the formula
=A1 * 7
fill the formula down to row 30. Excel will automatically change the row
number in the A# part of the formula, so down at row 30 it will have become
=A30 * 7.

Quick way to Fill the formula: after entering the formula in B1, select
cells B1 through B30 and use Edit -- Fill -- Down

"Melissa in Salem" wrote:

Hi again,

OK, here is another try, same thing. We know in adding numbers in a
vertical fashion, the formula covers a range of cells (=SUM(A1:A30)
-- that's a vertical stack of numbers.

A horizontal example: I want to multiply whatever the number is
in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want
it
set up so that, like, in A1thru A30, the Col A number gets
multiplied by 7 and that figure shows up next to it in column B. So
it's multiplying across.

B1 = A1 x 7.
B2 = A2 x 7 etc.

Is there a formula for that and where does it go? It seems to me I
would have to enter the formula each time. Am I right or wrong?

The real Horizontal Formula question
 

In B1 enter formula the below formula and drag/copy it down as required.
=A1*7

If you want to get the sum of all numbers in A1:A30 multiplied by 7 the
formula is

=SUMPRODUCT(A1:A30)*7


If this post helps click Yes
---------------
Jacob Skaria


"Melissa in Salem" wrote:

Hi again,

OK, here is another try, same thing. We know in adding numbers in a
vertical fashion, the formula covers a range of cells (=SUM(A1:A30)
-- that's a vertical stack of numbers.

A horizontal example: I want to multiply whatever the number is
in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want
it
set up so that, like, in A1thru A30, the Col A number gets
multiplied by 7 and that figure shows up next to it in column B. So
it's multiplying across.

B1 = A1 x 7.
B2 = A2 x 7 etc.

Is there a formula for that and where does it go? It seems to me I
would have to enter the formula each time. Am I right or wrong?

The real Horizontal Formula question
 

Oops..

=SUM(A1:A30)*7

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

In B1 enter formula the below formula and drag/copy it down as required.
=A1*7

If you want to get the sum of all numbers in A1:A30 multiplied by 7 the
formula is

=SUMPRODUCT(A1:A30)*7


If this post helps click Yes
---------------
Jacob Skaria


"Melissa in Salem" wrote:

Hi again,

OK, here is another try, same thing. We know in adding numbers in a
vertical fashion, the formula covers a range of cells (=SUM(A1:A30)
-- that's a vertical stack of numbers.

A horizontal example: I want to multiply whatever the number is
in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want
it
set up so that, like, in A1thru A30, the Col A number gets
multiplied by 7 and that figure shows up next to it in column B. So
it's multiplying across.

B1 = A1 x 7.
B2 = A2 x 7 etc.

Is there a formula for that and where does it go? It seems to me I
would have to enter the formula each time. Am I right or wrong?

The real Horizontal Formula question
 

On Jun 12, 11:43*pm, JLatham
wrote:
See my response in your other thread. *Repeat the essence he
In B1 put the formula
=A1 * 7
fill the formula down to row 30. *Excel will automatically change the row
number in the A# part of the formula, so down at row 30 it will have become
=A30 * 7.

Quick way to Fill the formula: *after entering the formula in B1, select
cells B1 through B30 and use Edit -- Fill -- Down

"Melissa in Salem" wrote:
Hi again,

OK, here is another try, same thing. *We know in adding numbers in a
vertical fashion, the formula covers a range of cells (=SUM(A1:A30)
-- that's a vertical stack of numbers.

A horizontal example: *I want to multiply whatever the number is
in cell A1 by 7 and have it show up in B1 (B1 = A1 x 7). *And I want
it
set up so that, like, in A1thru A30, the Col A number gets
multiplied by 7 and that figure shows up next to it in column B. So
it's multiplying across.

B1 = *A1 x 7.
B2 = A2 x 7 * etc.

Is there a formula for that and where does it go? *It seems to me I
would have to enter the formula each time. *Am I right or wrong?



Excellent!! OK. You answered my ?. Excel will fill the correct A
[number] as it goes down without me having to do it on every line.
This is great. Thank heaven for this group. You guys are good.

Melissa