Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill button is not appearing when I select cells in Excel 2007 | Excel Worksheet Functions | |||
Autofill in 2007 | Excel Discussion (Misc queries) | |||
Autofill - Excel | Excel Worksheet Functions | |||
How can I get excel to autofill the next column? | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |