| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I insert a row without the formula changing?
Hi
I am running an order spreadsheet where the latest orders are inserted in row 2, I have a formula in another tab keeping a tally of number of each items ordered on each day. When I insert a row, all my formulas change to only count values fron a row down from where they should =SUMPRODUCT((DATA!F2:F20000="13978 Auto Adaptor")*(DATA!J2:J20000=E9)) Also I wonder if there is a way to get the formula to sum a QTY column with the above restrictions Any help would be greatly appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I insert a row without the formula changing?
On Thursday, August 2, 2012 9:44:01 AM UTC-5, CLC07 wrote:
Hi I am running an order spreadsheet where the latest orders are inserted in row 2, I have a formula in another tab keeping a tally of number of each items ordered on each day. When I insert a row, all my formulas change to only count values fron a row down from where they should =SUMPRODUCT((DATA!F2:F20000="13978 Auto Adaptor")*(DATA!J2:J20000=E9)) Also I wonder if there is a way to get the formula to sum a QTY column with the above restrictions Any help would be greatly appreciated -- CLC07 try putting 0 in row 2HIDE it and insert at row 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Row without changing formulas | Excel Programming | |||
| Relative Formula References NOT changing After Insert From VB | Excel Programming | |||
| Stop cell reference in formula changing when insert column? | Excel Discussion (Misc queries) | |||
| Insert spreadsheet - without changing appearance? | Excel Discussion (Misc queries) | |||
| how do I insert a row without the formula changing? | Excel Discussion (Misc queries) | |||
Linear Mode
