• flickr
  • linkedin
  • twitter
  • rss
SUMPRODUCT – filtering and totaling data from columns

SUMPRODUCT – filtering and totaling data from columns

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:

Larry's a 30-something chap interested in travel, being a dork and changing the world via less boring training.

Leave a reply