Hi Folks,

First post here, so please be easy on me.

I have a formula that finds the total qty of shipped items between 2 dates. The formula works great; however, the number of rows of the data sheet "SHIPPED ORDERS" increases every day. (In the example below the number of rows is 393).

*=SUM(IF('SHIPPED ORDERS'!$K$2:$K$393=$B6,IF(('SHIPPED ORDERS'!$Q$2:$Q$393<=(D$2))*('SHIPPED ORDERS'!$Q$2:$Q$393>=(D$1)),'SHIPPED ORDERS'!$S$2:$S$393,0),0))*

So I want to make one simple change:

I know how to auto calculate the number of rows and have put that number in cell "A1".

How do I reference the value in cell "A1" (which is dynamic, but currently a value of 393) from the formula above. I do not want to have the number 393 in my formula at all... just a reference somehow to the value of "A1".

PS.... I have tried using INDIRECT () but could not get it to work in the middle of my formula.

One other note, the formula above is an array, so I use Ctrl-Shift-Enter to enter it...

Thanks in advance!