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?
 

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

Replace ; with , in functions 1
Sumif number is greater than a number but less than another number 2
Autofill column values in formulas 4
SUMIF with 2 ranges and 2 criteria's, totaling the same sum range. 10
SUMIF and INDIRECT reference to tab in other workbook 3
Autofill in 2007 10
Formula to return column letters 4
HELP!!! I need macro to autofill 4

Back
Top