SUMPRODUCT

Yes, it’s an Excel function. One I knew about, kind of, but had never needed to use, until today. Luckily, for all of us who were working on this formula, I found this page using Google and it made for an easy to follow example of summing the data in cells that matched mulitple criteria. Who said using the Web at work was unproductive?

Tags: SUMPRODUCT, Excel, Google

Similar Posts

  • I take it back

    Long time readers may remember this post, when I requested Law-firm IT folks take some time and train their users not to send links to documents from their document management system when sending them outside their firm. Now that I am one of those folks, I’d just like to say, I’m sorry. I take it…

  • Updates

    Sorry for the delay in posting, Blogger was doing some back-end upgrades, which I hope will make this stuff even better! Also, sorry for those of you who might have found a 404 when trying to get to this page very early this morning. I don’t know how but it just disappeared off the server….

  • Consumer Reports

    Related to the last post, I found a copy of the latest issue of Consumer Reports in the office and took a peek at their ratings. They rate a Gateway number 1, Toshiba 2nd, IBM 3rd and a Dell 4th, with the Dell being the “best buy” because it’s 400-600 dollars cheaper than the others….

  • Jumping into the fray

    Just because I think his stance is completely inconsistent and someone should take him to task over it. Robert Scoble, Feb 28, 2005 talking about Autolink: “I believe that anything that changes the linking behavior of the Web is evil. Anything that changes my content is evil. Particularly anything that messes with the integrity of…

  • Archiving

    Can I ask a question to those of you who work in IT? I need some honest opinions here. I’m thinking about archiving some stuff off our file server onto CD because I don’t, in all honesty, think we need it at all, but some people are reluctant to delete anything “just in case I…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Find out more about Webmentions.)