In MS Excel, how do I make the cell in the column E of the current row equal the product of the cells in columns D and C in the current row?
GQ surely, but I’ll take a stab at typing =(C1+D1) into the cell E1. Replace the number 1 with whatever row number you’re working with.
I believe you need =SUM(C1+D1)
I would have *sworn *I put it in GQ!
OK, I guess I can work with the sum function instead of the product, it will still be the same.
But I don’t want to say SUM(C1, D1). I want SUM(C[CurrentROW], D[CurrentRow])
IOW, I trying to get a general forumula whereby I have excel look at the *row *I am in, go to column C and take that number.
This is totally incorrect. The format is a colon.
I’m finding it difficult to understand exactly what you’re looking for, but I’ll take a stab that, you want a single cell in column E to equal the product of the cells in C and D?
Is the cell in E in the same row as the numbers you want added in C and D?
If so, then E1 should be =SUM(C1:D1), and if you copy and paste this formula, or drag the bottom-right corner of the cell in E down all the rows you want to effect, then it will alter the 1s to the particular row the formula is in - i.e. if you put the formula in E1 and paste it into E9, then Excel will automatically update the row number to =SUM(C9:D9)
You might be wanting something more complex, but you’re not explaining it very comprehensively…
Correcting my correction: brownie55 I apologise; didn’t realise this was an allowable format. However, the colon-range is (in my experience anyway) a more normal usage, and better for the OP - in case he wants to add any more columns in.
If you type =PRODUCT(C1, D1) into E1, and copy it into E2, Excel will automatically adjust the row number for you.
No problem. And the more I look, the less certain I am of what the OP wants exactly, so I’ll bow out.
=PRODUCT() will multiply the numbers, not add them!
Thank you, that is what I wanted to know.
A) I said words to that effect in post #6, and b) how did ultrafilter manage to give you a formula that is totally different from what you appeared to ask for, and yet to your satisfaction?!
My apologies. Thank you for your help.
Even easier: highlight E1, and drag the right corner down as far as you want to go - it will automatically copy & paste into all those cells.
The OP asked for the
You provided information on the SUM function.
:smack:
There’s a drag and copy function isn’t there? Click on the bottom right of a selected cell and drag it down across the cells you want to copy the equation to, it’ll adjust the row number too.
:smack: I didn’t see “product”, so yeah, I’m right about the forum, wrong about the equation 
Thanks to all who contributed.
Once you get the desired result in E1, select it and as many cells as you want in the column, then do Fill Down. Excel will automatically adjust the formulas for rows 2, 3, etc. (IIRC, YMMV, etc. I haven’t created a new spread in a while.)