isrdebie wrote:
> 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.


The weather is quite hot. Here is 5.37 am and I'm quite going to sleep...

Here is my complete solution with SUMPRODUCT:

http://rapidshare.de/files/30170929/...ified.xls.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy