Forum Discussion
Sum Array based on Date Range (Date Range Changes per Dimension)
In B21: =SUMIFS($B$3:$B$10, $C$3:$C$10, ">="&$B$14, $C$3:$C$10, "<="&$C$14, $E$3$E$10, B$20)
Fill or copy to C21.
In B22:=SUMIFS($B$3:$B$10, $C$3:$C$10, ">="&$B$14, $C$3:$C$10, "<="&$C$14, $E$3$E$10, B$20, $A$3:$A$10, $A22)
Fill or copy to C22, then to row 23.
Similar for B24:C26, but with $B$15 and $C$15.
Hi Hans, sumifs won't work.
This sample data is simple, only has two project in it, so we can point to that specific cell to get that project's time range. But in real data. the Project are hundreds, and the name is like "Timesheet Sept", "Store In the East", random names. So the formula needs to somehow look for the project's start and end date based on its name; then use its start/end date to sum the hours that NOT linked to any project.
Thank you.
Could you attach a small sample workbook without sensitive data that illustrates your problem?
