How do I insert a row without the formula changing?

C

CLC07

Hi

I am running an order spreadsheet where the latest orders are inserte
in row 2, I have a formula in another tab keeping a tally of number o
each items ordered on each day. When I insert a row, all my formula
change to only count values fron a row down from where they should

=SUMPRODUCT((DATA!F2:F20000="13978 Aut
Adaptor")*(DATA!J2:J20000=E9))

Also I wonder if there is a way to get the formula to sum a QTY colum
with the above restrictions

Any help would be greatly appreciate
 
D

Don Guillett

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
Click to expand...

try putting 0 in row 2>HIDE it and insert at row 3
 

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

How do I insert a row or rows between each row of text and copy the row above? 0
Insert Blank Row with data match change 1
how to find text vaues for a given grade? 0
Insert Row and Countif Macro 1
copy/paste row with one formula 6
Multiple "IF" statements in a formula 1
Insert Row with formula 1
Use macro to write formula 1

Top