I am using this sumproduct function in our project summary log to retrieve a
range of cells that contains "Richard Horn" (project Lead) but not if they
contain "carried forward" or "completed" (project statuses).

=SUMPRODUCT(('Q4'!D9:D39="Richard
Horn")*('Q4'!E9:E39<"completed")*('Q4'!E9:E39<"c arried
forward")*('Q4'!E9:E39<"on hold"))

What I also wanted to do was to say only pull those within a specific date
range like below.

=COUNTIF(I9:I39,"=10/01/09")-COUNTIF(I9:I39,"12/31/09")

Can I combine or re-write this function into one function?

Thanks, Richard