function help!

  • Thread starter Thread starter stephaniearaujo22
  • Start date Start date
S

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 ?
 
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
 
Can you elaborate your requirement..
=SUMPRODUCT(range1,range2) will do exactly what you mentioned in your
original post.

If this post helps click Yes
 
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.
 
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
 
Back
Top