ExcelBanter - Using autofill in Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using autofill in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/236777-using-autofill-excel-2007-a.html)

Debs1967

Using autofill in Excel 2007

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

Using autofill in Excel 2007

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

All times are GMT +1. The time now is 11:31 AM.