isrdebie wrote:
Franz,

Thanks. I hope you are still out there. I uploaded to
rapidshare.com. Here's the link. Thanks again. I'll start checking
into SUMPRODUCT.

http://rapidshare.de/files/30165244/...ample.xls.html

Let me know if I messed it up.

Maybe this is what you are looking for:

=SUM((IF(G2:G27="RTA",H2:H27,G2:G27)=L2)*(IF(G2:G 27="RTA",H2:H27,G2:G27)<=M2)*I2:I27)

the formula must be array entered, i.e. you have to press CTRL + SHIFT +
ENTER instead of just ENTER...

In L2 you have the starting date you want to evaluate while M2 is the last
date of your interval.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy