everydayExcel Newsletter Header

Excel's SUMPRODUCT Formula is BIG Deal!

When I first learned about the SUMPRODUCT formula in Excel, I almost dismissed it as a useless formula used by only few users. How often would anyone need to multiply 2 or more groups of numbers together and add up the results!?

To get to the story, we know that SUMPRODUCT formula is keyed in as:

=SUMPRODUCT((B3:B7)*(C3:C7))

This is the same as taking B3 and multiply it by C3, followed by next set and so on. Then, add up the total derived. The answer is 41. The working is as follows:

Then I found out something really exciting ... more about sumproduct!

Lunch Time Talk - Budgeting Against Disaster

Date: 11 Feb 2009
Time: 12.00pm to 1.15pm
Venue: 10 Anson Road #26-02A International Plaza S(079903)
Fees: FREE!

Forward this to your friend(s) who might be interested in this talk.

What's New in Excel 2007

In the older versions of Excel, we have to calculate the average of a range of numbers based on the condition using a combination of SUMIF divided by COUNTIF. In Excel 2007, you can calculate the average with a new single AVERAGEIF formula. The inputs are the same as ...continue from our section on Learning Microsoft Excel 2007

On the Lighter Side

Don't be fooled by deceptive labelling such as "less", "natural", "reduced", "free", "light", and "diet"!

Because food manufacturers and suppliers are becoming more creative in presenting information on the food label to the consumers, we really need to become smarter when shopping. Begin to be an avid food label reader with 8 simple pointers to see through the marketing hypes on food packaging. All "Did You Know Reading Food Label Can Be So Tricky?"

Many of you could not find the link to the following health alert in our last mail. Here it is:

"Are you sure you want to pop another sugar-free sweet into your mouth? Read "Aspartame - A Silent, Sweet Killer?" to be in the know about the huge sugar-free sweets debate."


Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.


Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.


Yours Sincerely,

Jason Khoo
Chief Trainer
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and 
"Excel Secrets for Highly Effective Marketers"

 

Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.