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

  • Password policy

    After my experiences today I’m reconsidering the way I look at password policies. I had to go around and install the new drivers for that Canon copier/printer today on about 15 machines. The install involved installing the Canon LPR port, installing the print driver, restarting, and then entering the Department ID information for the print…

  • The old switcheroo

    Since I couldn’t get past recreating that crash everytime I imported my OPML file into News Desk, I decided a change would do me good. So now I’m reading my news in Sharpreader, which has become a much nicer product in the time since I last tried, unsuccessfully, to use it! I was sort of…

  • |

    E-Discovery Impact on IT

    I thought this quote from a ComputerWorld article really sums up what I’ve been thinking since I moved into Litigation Support and out of a strictly IT job. ?[FRCP] has made their lives incredibly complicated,? Nirken said. IT is now responsible for immediately locating electronic files that ?can exist just about anywhere ? in networks,…

  • Whooo Hoo!!!!!!

    Congrats go out the the New York Islanders, who beat the Washington Capitals 5-4 last night to clinch their first playoff berth since 1994, when they were swept out of the first round by that “other” New York team. Bring on the NHL playoffs, there is seriously nothing like them! Follow these topics: Uncategorized

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.)