Fill question - fill part of formula but not others?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top