View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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