Multiplying a row by a number creating a new row with the answer
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
Desktop
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
by deniseborremans Accepted solution
by ---tk--- Accepted solution
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.
Sort by Trending