Contextures

Contextures
Excel news
by email

Contextures News

Excel Weekly News from Contextures Feb 7, 2012

The winter is unseasonably warm in most parts of North America, but areas of Europe are really suffering in the cold. Hope you're warm and safe, wherever you are! Stay indoors, and work on your Excel files.

-  Debra ddalgleish@contextures.com

SUMIFS  Function - Sum With Multiple Criteria

Use the SUMIFS function in Excel 2007 or later, to sum with multiple criteria. For example, what is the total amount for active accounts with 10 or more visits?

I've updated the Excel Sum page on the Contextures website, to include the SUMIFS function example and video.

COUNTIFS  Function - Count With Multiple Criteria

Similar to SUMIFS, you can use the COUNTIFS function in Excel 2007 or later, to count with multiple criteria. For example, how many orders were for pens, and had a quantity of 10 or more?

I have updated the Contextures Count functions page, to include a COUNTIFS example, and video demo. If you are using Excel 2003, or earlier versions, you can use the SUMPRODUCT function instead. There is an example for that function on the COUNT page too.

Poor Man's Sparklines in Excel

Sparklines are a new charting feature in Excel 2010, and let you create miniature charts for rows of data. On his PTS Blog, Excel charting expert, Jon Peltier, shows how Excel's regular charts can be used to create decent sparklines.

So, if you want this feature, you won't have to upgrade to Excel 2010 to get it!

Writing efficient User Defined Functions

Excel MVP, Charles Williams, is doing a programming series on his blog, that shows us how to write efficient User Defined Functions in Excel.

The latest installment covers Volatile Functions and Function Arguments. There is great information in this series, whether you are a beginner or pro at Excel programming.

Excel Humour

Once again, I read the Excel tweets, so you don't have to! Here are a few favourites from this week. You can read the rest of the tweet collection here.

• Who knew making a graph in excel could be as hard as cracking the da Vinci code