If+if+if+if... Does anyone know a better way?
Hi. I have this equation:
=(IF(($Q10=$C$10)*($Q10<=$D$10),J$10,0))
+(IF(($Q10=$C$11)*($Q10<=$D$11),J$11,0)) +if+if+if... and so on...
Which means:
if (date = startdate and date <= endate) then show the value for that day,
or 0 if date doesn't fall inbetween the start and end date...
Which is working but I need to do this for every day of the month so: a/
Excel won't let me write an equation long enough to have 31 of these and b/
it's a real pain having to write it out for every month!
Does anyone know a better way?! Thanks!
|