software

I have read through other posts and the language is way too quot;in depthquot; for me
to understand. I need to apply a function to an entire column without going
through each cell and entering it.

Example:
B2 is sale price, C2 is cost, D2 is profit. I need to continue this formula
down the entire sheet. There are other parts too, but if I can figure it out
on this level I can apply it to the rest.

One other question:
I have a varying number of entries for each month with a row at the bottom
for totals. Is there a way that I can add the entries as I go along moving
the quot;totalquot; row down as I go?

P.S. I am no idiot, but not very experienced with this program. Please make
answers simple as related to the program.

Thanks a lot

Select the cells in which you want to enter the formula. Type the
formula in the first cell and press Ctrl Enter to fill the
selected cells with formula.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;jsthngnquot; gt; wrote in message
...
gt;I have read through other posts and the language is way too quot;in
gt;depthquot; for me
gt; to understand. I need to apply a function to an entire column
gt; without going
gt; through each cell and entering it.
gt;
gt; Example:
gt; B2 is sale price, C2 is cost, D2 is profit. I need to continue
gt; this formula
gt; down the entire sheet. There are other parts too, but if I can
gt; figure it out
gt; on this level I can apply it to the rest.
gt;
gt; One other question:
gt; I have a varying number of entries for each month with a row at
gt; the bottom
gt; for totals. Is there a way that I can add the entries as I go
gt; along moving
gt; the quot;totalquot; row down as I go?
gt;
gt; P.S. I am no idiot, but not very experienced with this program.
gt; Please make
gt; answers simple as related to the program.
gt;
gt; Thanks a lot