Formula question

  • Thread starter Thread starter John Bordieri
  • Start date Start date
J

John Bordieri

Hi,

Is there a easier way to to multiply a whole column with another column to
get the result in another column without doing the formula line by line?

I have an inventory speadsheet with just over 700 lines. I am trying to get
column "C' to multiply with column "E" and have the total show up in column
"F". I know I can add the formula in line by line, but it would take too
long. Any suggestions?

column "C" column "E"
column "F"
item count price
total
2 (x) $2.00
(=) $4.00
3 (x) $3.00
(=) $9.00
etc.


Thank you,
John
 
Hi

Do the formula once and use AutoFill to copy it down. Once you've entered
the first one (eg. =C2*E2), reselect the cell and in the bottom right-hand
corner is a plus sign. Put your mouse on this and drag it down. This will
copy your formula down, incrementing the cell references as you go.
 
put the formula in the 1st cell and copy\paste down or use the fill handle
by grabbing the lower right corner of the cell and dragging. If you just
want the total of this exercise you don't have to do individually. This will
do it all. With sumproduct, you cannot use E:E or F:F. You must use a range
=SUMPRODUCT(E1:E300,F1:F300)
 
"Put your mouse on this and drag it down." ...or put your mouse on it and
double-click. Excel will copy the formula down Column F until it no longer
sees entries in Column E.
 
OK!! I was trying to put it in simple terms so that the poster could see
what was going on!! :=)
 
....and you did a great job, Andy. You always do. I just thought I'd take the
opportunity to show the poster there was yet another way. ;-)
 
Back
Top