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!