Calculate Total Sales by Product Category
I need to sum up the total revenue generated specifically from the 'Electronics' category in my sales log.
=SUMIF(B2:B9,"Electronics",C2:C9) How it works: The SUMIF function works by evaluating cells in a specified range (B2:B9) against a given criterion ("Electronics"). For every cell in the criteria range that matches 'Electronics', it adds the corresponding value from the sum range (C2:C9) to a running total. This allows the Small Business Owner to quickly isolate and sum sales data for specific product categories without manually filtering or sorting.
Data Setup
| Order ID | Product Category | Sales Amount |
|---|---|---|
| 1001 | Electronics | 150.00 |
| 1002 | Apparel | 75.50 |
| 1003 | Electronics | 220.75 |
| 1004 | Home Goods | 120.00 |
| 1005 | Apparel | 50.00 |
| 1006 | Electronics | 300.00 |
| 1007 | Home Goods | 90.25 |
| 1008 | Electronics | 180.50 |
Step-by-Step Guide
**Identify the Criteria Range:** Locate the column that contains your product categories. In our example, this is column B ('Product Category').
**Define the Criteria:** Specify the exact category you want to sum. In this case, it's "Electronics". Remember to enclose text criteria in double quotes.
**Identify the Sum Range:** Locate the column that contains the values you want to sum. In our example, this is column C ('Sales Amount').
**Construct the Formula:** Combine these elements into the SUMIF function. If your data starts from row 2 (with headers in row 1) and goes down to row 9, the formula would be `=SUMIF(B2:B9,"Electronics",C2:C9)`.
**Enter and Apply:** Type this formula into an empty cell and press Enter to see the total sales for the 'Electronics' category.
Explore More
Summarizing Expenses by Category
As a small business owner, I track all my expenses in an Excel sheet. At the end of the month, I need to know the total spent on specific categories like 'Utilities' or 'Office Supplies' for budgeting and tax purposes. Manually adding these up is tedious and error-prone.
Determining Monthly Payments for New Equipment Financing
A small business owner needs to finance new equipment to expand operations and wants to calculate the fixed monthly payment required for the lease, given the equipment's total cost, the annual interest rate, and the lease term in years, to manage cash flow effectively and make informed investment decisions.
Find Price by Product Name (Case Insensitive)
As a small business owner, I often need to quickly look up the price of a product for a customer or to update inventory. My product list might have inconsistent capitalization (e.g., 'Widget A' vs 'widget a'), and I need a reliable way to find the price even if my search term's capitalization doesn't exactly match the database.
Calculate Equipment Lease Monthly Cost
I need to figure out the monthly payment for a $15,000 piece of machinery leased over 3 years at 5% interest.