Using autofill in Excel 2007

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.
 
D

Dave Peterson

I'm confused.

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

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

Sumif number is greater than a number but less than another number 2
Autofill column values in formulas 4
SUMIF and INDIRECT reference to tab in other workbook 3
Formula to return column letters 4
Autofill in 2007 10
Sumif based on column A and title of another column 7
Using Indirect in a Sumif Function returns the wrong answer 4
Autofill series with keyboard 7

Top