Using autofill in Excel 2007

  • Thread starter Thread starter Debs1967
  • Start date Start date
D

Debs1967

How do I autofill a =SUMIF formula so that the range inreases but the
criteria and sum_range remain the same please? I'm using Excel 2007. Thank
you.
 
I'm confused.

If the criteria range changes size, wouldn't you want the sum range to reflect
that change, too?
 
Back
Top