Two Questions:
If Y$29:IV$29 are dates, "&$C$5 and "&$C$6 are the start and end dates of a
unit, $Y33:$IV33 are hours to be totaled, why doesn't the second formula work
the same as the first?
=SUMIF(Y$29:IV$29,"<="&$C$6,$Y34:$IV34)-SUMIF(Y$29:IV$29,"<"&$C$5,$Y33:$IV33)
=SUMIF(Y$29:IV$29,AND(">="&$C$5,"<="&$C$6),$Y33:$IV33)
I now want the formula to also only add the hours if the date falls on a
Monday or Wednesday in the unit. How can I do this?
Thanks,
Stacy
Bookmarks