Fill question - fill part of formula but not others?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Example:

This sums values from a different excel worksheet (for the month of
September), only if the value is given by the name in A478.

=SUMIF('2004'!C360:C403,A478,'2004'!E360:E403)


WHen I fill down though, ALL the cell references change, ie:
=SUMIF('2004'!C361:C404,A479,'2004'!E361:E404)

but what I need is for only the local refence, A479 (the name of the
company), to change in the formula.

Is there anyway to do this? (besides manually?)

Matt
 
Back
Top