I'm confused.

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

Debs1967 wrote:

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.

--

Dave Peterson