Franz Verga wrote:
> 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


Just for precision...

It's not a real SUMPRODUCT, but I used the SUM function array entered,
because I needed an IF function inside and with IF you always need to array
enter (if you are working with arrays...) even if you are using SUMPRODUCT,
so I preferred to use SUM instead...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy