I think you are looking for the "fill down" command.

Basically, type your formula into the first Y column (=Sum(X1)*180). Then,
notice that the cell you are in has a dark bold outline and a square at the
lower right corner . Click that little square and drag down to the end.

This will probably do the trick, but you might want to do a quick google
search on "absolute vs. relative references" for some more info that might
be helpful.

Heidi

"aquaflow" wrote:

I have values in X col and would like Y col to be populated based on X.
like SUM(X1)*180. How can i do that ? since the col had 900 rows its
tedious task.