Fill question - fill part of formula but not others?

[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

 

[Guest]

try this:
=SUMIF('2004'!$C$360:$C$403,$A$478,'2004'!$E$360:$E$403)

 

[Frank Kabel]

Hi
use:
=SUMIF('2004'!$C$360:$C$403,A478,'2004'!$E$360:$E$403)

 

[Guest]

THanks, worked great.

Matt

try this:
=SUMIF('2004'!$C$360:$C$403,$A$478,'2004'!$E$360:$E$403)