Franz,

Thanks for your help. I did find a solution. While looking at
SUMPRODUCT, I also looked over SUMIF and conditional sum. I am using
the conditional sum add-in, with a SUMIF formula. I created a
condition to sum the price sold column if the DATERANGE is = 1/1/06.
Worked like a charm. Thanks. What's the weather like in Italy. Is it
morning there. It's 8:00 pm here and just about time to wind down for
the night. Thanks again.


--
isrdebie
------------------------------------------------------------------------
isrdebie's Profile: http://www.excelforum.com/member.php...o&userid=37798
View this thread: http://www.excelforum.com/showthread...hreadid=573604