how about
=SUMPRODUCT(($C$10:$C$40=startdate)*($D$10:$D$40< =enddate)*($J$10:$J$40))
Or reverse the start and end date if I just switched them on you

"Statler" wrote in message
...
Hi. I have this formula:
=(IF(($Q10=$C$10)*($Q10<=$D$10),J$10,0))
+(IF(($Q10=$C$11)*($Q10<=$D$11),J$11,0))...and so on

which means:
if (startdate = date or enddate<= date) show value in J and if not, show
0

...and I need it to do this for every day in a month. However, a/ Excel
won't let me nest 31 if functions like this and b/ it's a real pain typing
it
out for every month!

Does anyone know a better way? Thanks!