Keeping in Touch
Getting the Most from Your Sage 100 Investment 
Jul 2013, Issue 61
Newsletter Contents
Quote to Ponder
Quarterly Webinar
Introduction to Crystal Reports
Excel Tip - COUNTIFS and SUMIFS
Join Our Mailing List!
Quick Links

 

 

 
 
Dear ,

Welcome to the hot days of summer.  Before you take off for summer vacation, consider taking our Introduction to Crystal Reports class on Jul 30/31.  See details below.

This newsletter, Keeping in Touch, is our way of keeping you up to date with relevant news about your Sage 100 (formerly MAS 90 / 200) software and also what's happening at Munjal White.

We're always looking for ways to improve, so if you have any suggestions for newsletter topics, tips, or other ways that we can improve our service level, click here to let us know. 

The annual Sage Customer conference is this month (July 23-26) in Washington, DC.  Will you be there?  Click on the Quick Link to the left to learn more about this knowledge-and-network-building conference!  If you purchased your Sage 100 software after August 2012, you may be entitled to attend the conference for free!  Click here to find out if you're eligible. 
 
Quote to Ponder

Listening is not a skill, but a decision    

Unknown 

 

Quarterly Webinar
Your support agreement with Munjal White entitles you to attend our quarterly webinar series at no additional cost.  We encourage you to take advantage of these webinars.

The next quarterly webinar is on Tuesday, September 17th . . . the topic is What's New in Sage 100 ERP 2013 (aka v5).  Additional information and the registration website will be announced in next month's newsletter.

Introduction to Crystal Reports   

Is Crystal Reports your next big challenge?  Summer time can be a slow time, so why not consider taking a class with us!  Crystal Reports can help you gain insight into trends in your business.

Join us on Tuesday and Wednesday, July 30 and 31 at our Introduction to Crystal Reports class.  The class will teach you all you need to know to feel comfortable working with Crystal Reports, creating your own reports, and modifying existing reports (standard or custom).  This hands-on class is taught using your Sage 100 data and you will have the opportunity to suggest reports that we will use as training exercises.

Please click on this link to learn more about the class and to register.  If you have any questions, please let us know.

   

Excel Tip - COUNTIFS and SUMIFS

Are you familiar with the Excel functions COUNTIFand SUMIF?  I've been using them for years and they have been very helpful analyzing data.  Did you know there are also new functions called COUNTIFS and SUMIFS which allows you to count or sum based on multiple criteria?  This is available in Excel 2007 and higher.

For example, consider the following data table.

Count the number of customers in ON that had sales greater than $1,000,000.  You could use this formula  =COUNTIFS(A2:A12,"ON","D2:D12",">1000000").  The result is 3

What is the total of all sales of Mary's customers that are in QC.  You could use the formula =SUMIFS(D2:D12,A2:A12,"QC",B2:B12,"Mary").  The result is 580,003

ExcelDataTable

Imagine what you can do with this extra functionality!

To quote Sheldon in the TV show The Big Bang Theory --- You're Welcome!        

We look forward to your feedback and your ideas for future issues of our newsletter.  If you would like to contribute an article or suggest an article or support tip to a future newsletter, we'd love to have your contribution.  Please let us know how we can help you Get the Most from Your Sage 100 Investment.

 

Sincerely,

 

    Shabnam and Robert