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
 
Ad

Advertisements

G

Guest

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

Frank Kabel

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

Advertisements


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

Similar Threads

Fill formula question 1
Formula fill... 4
Filling a Formula 1
Formula filling 5
Formula filling???? 2
Filling in Formulas 1
Fill Formula please 5
Formula Fill Help 0

Top