Pretty handy. I used this for calculating remaining capacity for more work with forecasting project plans. I remember thinking Excel was sooo boring when I was little, and now I’m all, Exhell yea!
Each of these spans (arrays) with an ‘=’ or >= etc. is just another filter – so you can cram as many as you want in there, it’s neat.
=SUMPRODUCT((dates>='week plan'!E3)*(dates<='week plan'!F3)*(products=$A$1)*(deliverable_1!$D8:$D52))
Tech Reference: Excel
Leave a Reply