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.
Print This Post
|
|
|
|
|
 |
Related Posts -
Slacking Off at Work Photo by cell105 As we get toward the end of the year, people in my area of expertise (finance) tend to get busy. Very busy. It starts just before Thanksgiving, and just gets crazier as the end of the year gets closer. So today it's Thanksgiving, and I'm planning...... -
A Simple Mortgage Amortization Table Kevin over at the No Debt Plan blog recently advised his readers to avoid mortgage accelerator programs like the plague. He reasoned that you could set up your own mortgage accelerator program by adding 1/12 of a payment as additional principal to each month's payment. I agree with Kevin. You...... -
Excel Tip: Have Your Cell Contents = Tab Names It's time for another edition of Stupid Excel Tricks! One of my coworkers recently asked me an Excel question. He had a spreadsheet with multiple tabs, and wanted to have the value in cell A1 on the respective worksheets to be the name of each tab. I knew that it......
Related Websites -
The Friday gathering - Updates and cell phones I've received a number of emails from readers asking about the status of our move. First let me say thanks. I am always overwhelmed at how much you guys care about my life and what's going on. I also have a number of reader's who've said they are praying...... - 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......
-
Red Nag Champa - 40 Gram Box - Shanthimalai Incense User Reviews Send this to a friend Red Nag Champa - 40 Gram Box - Shanthimalai Incense Manufacturer: Shanthimalai Customer Rating: List Price: Varies based on product options Sale Price: $5.69 Availibility: Usually ships in 24 hours Free Shipping Available Buy Now Product Description Exquisitely perfumed, this incense sets......
