Search Contextures Sites
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 firstname.lastname@example.org
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.
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
- Trying to make an Excel spreadsheet for 20mins, boss goes "just ask someone to send you the one that's already made"
- I'm gonna be honest with you, twitter; I don't really understand what a pivot table is.
Recommended Excel Tools
Contextures Inc., Copyright ©2017
All rights reserved.