I have a similar sheet set up to return orders received by month. The
array (CTRL+SHIFT+ENTER) formula for January looks like this:

{=SUM(IF(Master!$F$4:$F$3972=$A276,IF(Master!$D$4: $D$3972=DATEVALUE("1/1/2004"),IF(Master!$D$4:$D$3972<DATEVALUE("2/1/2004"),Master!$H$4:$H$3972,0),0)))}.

"Master" is the main sheet into which all incoming orders are entered.
The first range is the column to look in for the comparison. =$A276
means only lookup those items in Master that match cell $a276 (the part
number in my case) and then only those values = Jan.1 or <= Feb.2. If
all this is true, then add up the values in Master Column H (the sales
values). Otherwise, return 0.

Hope this helps.


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=319909