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