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 ?


.