The SUMIF function is an easy way to get a subtotal of specific data that meets a certain condition, without going through the trouble of producing a Pivot Table.  It’s most useful when working with long arrays of diverse data:

Note: You can follow along with this how-to by opening this Excel file: SUMIF function.xls

In the above chart, let’s say we wanted to summarize the Sales and Profit totals for Gonzalez.  In cell B20, we enter “Gonzalez” as the condition to check for.  Next, we enter the SUMIF formula in cell C20:

This gives us a summary of the Sales amounts attributable to Gonzalez.  We can copy this formula to cell D20 in order to total up his Profit:

Finally, we can compute his Profit % by dividing cell D20 by cell C20.  SUMIF formulas can be created for each of the managers if you so choose.

• Deming's Seven Deadly Diseases I've wrote about W. Edwards Deming and his 14 Points in a previous post.  You can read it here.  Today, I'd like to talk about his Seven Deadly Diseases.  These were the ailments that Deming saw as reason for the decline of Western Management: Lack of constancy of purpose to......
• Outsource-Proof Jobs This article on Yahoo Education listed the best jobs that will not be outsourced overseas.  Let's take a closer look at these: Education Administrator, Elementary or Secondary School Younger students will need live teachers, and live teachers require supervision by administrators.  I guess you could also add live teachers to......
• 11 Ideas for New Income Streams Camra_ Art I read an article at Kiplinger.com entitled 11 Ways to Get Extra Cash.  I'm always looking for new income streams, so here's my take on the suggestions: 1. Sell your stuff online So far, I've only bought stuff online.  I'm not big on garage sales, but maybe......

• Have you measured yours lately? Some marketing performance metrics I woke up dreaming about this morning... Revenue Ratios Response rate = Response volume / Exposure volume Sales volume = how many sales Average sales value = Total revenue / sales volume Average Purchase Cycle = Total time taken for all sales / Customers Cost Ratios......
• Using Or criteria To count cells by using an Or criterion, you can sometimes use multiple COUNTIF functions. The following formula, for example, counts the number of sales made in January or February: =COUNTIF(Month,”January”)+COUNTIF(Month,”February”) You can also use the COUNTIF function in an array formula. The following array formula, for example, returns the......
• Use Correlation Test of MS Excel Data Analysis of Excel has a function to determine the relationship between two variables.  Result of this function is coefficient of correlation which shows the strengh or weakness of a relationship. The value of coefficient ranges between -1.0 to +1.0 How to run the correlation test? Prepare two data sets......