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 ?

Not sure I understand. Maybe something like this:

=SUMPRODUCT(A8:A20,D8:D20)

--
Biff
Microsoft Excel MVP


"stephaniearaujo22" wrote in
message ...
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 ?

Try
=SUMPRODUCT(A2:A10,D2:D10)

If this post helps click Yes
---------------
Jacob Skaria


"stephaniearaujo22" wrote:

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

"Jacob Skaria" wrote:

Try
=SUMPRODUCT(A2:A10,D2:D10)

If this post helps click Yes
---------------
Jacob Skaria


"stephaniearaujo22" wrote:

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 ?

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

If this post helps click Yes
---------------
Jacob Skaria


"stephaniearaujo22" wrote:

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" wrote:

Try
=SUMPRODUCT(A2:A10,D2:D10)

If this post helps click Yes
---------------
Jacob Skaria


"stephaniearaujo22" wrote:

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 ?

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.

"T. Valko" wrote:

Not sure I understand. Maybe something like this:

=SUMPRODUCT(A8:A20,D8:D20)

--
Biff
Microsoft Excel MVP


"stephaniearaujo22" wrote in
message ...
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 ?


.

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

"stephaniearaujo22" wrote:

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.

"T. Valko" wrote:

Not sure I understand. Maybe something like this:

=SUMPRODUCT(A8:A20,D8:D20)

--
Biff
Microsoft Excel MVP


"stephaniearaujo22" wrote in
message ...
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 ?


.