On Jun 12, 7:19*pm, Muz wrote:
Melissa

Assuming I have understood you correctly, you do it exactly the same
way.

So for example, to sum a list of numbers going horizontally in columns
A to F, row 1, and put the result in G1, then in G1 type =sum(A1:F1)

For doing things horizontally the letters change rather than the
numbers, as they do if you are calculating vertically.

Regards

Murray

On Jun 13, 10:53*am, Melissa in Salem wrote:

I know how to create formulas for calculations as long as the numbers
are stacked vertically, like adding top to bottom.

How do make formulas that go across the page horizontally? *Is that
possible? *I am sure it is but I am stumped.



Hi again Murray,

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

Now a horizontal example: I want to multiply whatever the number is
in col A1 by 7 and have it show up in B1 (B1 = A1 x 7). And I want it
set up so that, like, in A1:A30 each number in Col A numbers get
multiplied by 7 and that figure shows up next to it in column B. So
it's multiplying across. Is that explained well enough? B1 = A1 x
7.

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?