Simple Formula Questions (I hope)
Nobody is an idiot... I don't know Spanish, French, Mandarin etc etc, that
does not make me an idiot :-)
You got your solution from Bernard.
Pl. remember that if you have a $ in front of the letter (Column) and/or
number (row number) then that part of the formula does NOT change when you
copy across or down...
If there is no $ then letter changes (column) when dragged/copied right and
number (row) changes when dragged/copied down.
"Logues" wrote:
Thanks
Sum formula sorted as per advice below.
I've adjusted the Product one as you suggest but when I drag it down Column
C I get an Error in C14. I realised that that is becasue I'm an idiot and
what I actually want is:
C13=PRODUCT(B13*B11) to become C14=PRODUCT(B14*B11), C15=PRODUCT(B15*B11) etc.
Sorry ... got my columns and rows mixed up
Jas
|