Forum Discussion
help with formula
Hello, How is the simpliest way to solve this kind of problem (example file): I want to make easy resources planning table. First i insert work lines (department, year, planned start week, ...
If to take from the second table that could be
=SUMPRODUCT(($T$4:$T$7)*($E$4:$E$7=$V4)*($Q$4:$Q$7>=W$3)*($R$4:$R$7>=W$3))
second multiplier checks the department, third and fourth ones if the week is within your range, and we sum all what meet the criteria from latest column
You may add another AND conditions criteria, e.g. year