Copying formula

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I have the formula:-

{=AVERAGE(IF(C4:C37="MALE", D4:D37))}

I want to copy this to a range of cells, however when I drag it along, the
"C4:C37" then changes to "D4:D37" which I don't want it to do.

Is there anyway I can copy the above formula quickly so that I get:-

{=AVERAGE(IF(C4:C37="MALE", D4:D37))}
{=AVERAGE(IF(C4:C37="MALE", e4:e37))}
{=AVERAGE(IF(C4:C37="MALE", F4:F37))}
{=AVERAGE(IF(C4:C37="MALE", F4:F37))}

Thanks
 
Change the relative references to absolute references.
This prevents them from being changed during copying.

Change
C4:C37
TO
$C$4:$C$47

This can be accomplished rather easily by simply clicking within the cell
reference in the formula bar and hitting <F4>.

Each time you hit <F4>, you will see the absolutes cycle between column and
row, to row only, to column only, to none (original), and back again to
column and row.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have the formula:-

{=AVERAGE(IF(C4:C37="MALE", D4:D37))}

I want to copy this to a range of cells, however when I drag it along, the
"C4:C37" then changes to "D4:D37" which I don't want it to do.

Is there anyway I can copy the above formula quickly so that I get:-

{=AVERAGE(IF(C4:C37="MALE", D4:D37))}
{=AVERAGE(IF(C4:C37="MALE", e4:e37))}
{=AVERAGE(IF(C4:C37="MALE", F4:F37))}
{=AVERAGE(IF(C4:C37="MALE", F4:F37))}

Thanks
 
Thanks a lot for that!

You "Experts" who use this forum! You must have onethousand and one million
bits of info in your heads. Whenever anyone every asks a question in this
forum, they seem to get a reply and usually within 5 mins!

Thanks again to you lot! Appreciate it and this is one of the best NGs I
use!

Neil
 
Back
Top