Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically change ranges when copying formula
I have the following formulas in my worksheet
Row 2 =SUMPRODUCT(($N2:$N9<$H2)*($O2:$O9<$G$1)*($N2:$N9 =$L2)) Row 10 =SUMPRODUCT(($N10:$N12<$H10)*($O10:$O12<$G$1)*($N1 0:$N12=$L10)) Row 13 =SUMPRODUCT(($N13:$N20<$H13)*($O13:$O20<$G$1)*($N1 3:$N20=$L13)) As you can see there are different ranges in the formulas. What I am doing is copying the formulas into the relevant cells and manually changing the ranges. Having over 3000 to do will take a lot of time! Is there and easy way of copying the formula down the sheet to pick up the ranges. Each new range row is highlighted in TAN so I dont know if this could be used to find the new range. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change row and column when copying formula | Excel Discussion (Misc queries) | |||
Why Excel does automatically change the formula? | Excel Worksheet Functions | |||
Copying formula with cell reference decreasing automatically | Excel Discussion (Misc queries) | |||
formula help to change row colour automatically by some conditions | Excel Worksheet Functions | |||
Is there a way to automatically change the location of a formula? | Excel Worksheet Functions |