function help!

[stephaniearaujo22]

hi i have a spreadsheet that im doing for the inventory of my restaurant. I
have 300 rows and 5 Columns. My last columns is the total price of each row
for each different item. But the problem is i dont want to put a function in
each cell individually. Is there a way for me to add a function to all the
whole column of E.
The function im using is PRODUCT =A8*D8. The only thing that changes in
each function is the row number which equals the 8 in this example would
there be a way for me to select all of column E and put the function =A*D and
it would add the row number automatically ?

 

[T. Valko]

Not sure I understand. Maybe something like this:

=SUMPRODUCT(A8:A20,D820)

 

[Jacob Skaria]

Try
=SUMPRODUCT(A2:A10,D210)

If this post helps click Yes

 

[stephaniearaujo22]

I was wondering more if u can add a function to more than one cell at a time
.. Like if i were to select 50 cells and add a function to all of them instead
of going to each one and writing in a function

 

[Jacob Skaria]

Can you elaborate your requirement..
=SUMPRODUCT(range1,range2) will do exactly what you mentioned in your
original post.

If this post helps click Yes

 

[stephaniearaujo22]

Ok. So I want to add a function to every single cell in a column of over 200
cells, but i dont want to have to go to each individual cell to write in the
function so i wanted to know if it was possible to do it in all one shot.

 

[TroyT]

Ok, what you want to do is fill down. Select the first function you created
incolumn e (which is E2). You will notice that the highlighted cell has a
small box in the lower right hand corner. If you double click that, it will
fill down that formula until your data in D is complete. You also have the
option of dragging from that small box to any number of cells down.

Hope this helps.

TFT