Question Locked

Multiplying a row by a number creating a new row with the answer

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I take a column of numbers and mulitply it by the same number, and have the answer appear in a column beside?

ex: column A1 to A244 x 14=the answers to appear in column B

2 replies

by ---tk---

are you asking to add up A1 through A244 then * 14?

If so there is a couple different ways... in column A245 you could put =SUM(A1:244), and in column B place =(A245*14)

Added: or just in column B place =SUM(A1:A244)*14

This discussion is closed to new replies.