Example of using SUMIF function in Excel to calculate item-wise total sales.

The image shows an Excel worksheet with two tables:

1. "Date wise Sale" table (on the left), which contains daily sales data including:
- Date
- Name of Items
- Quantity Sold
- Rate
- Amount (calculated as Quantity × Rate)

2. "Item wise total Sale Amount" table (on the right), which lists the total sales amount for each item.

---

🔍 Problem:

We need to calculate the total sale amount for each item (Pen, Pencil, Sticker, Register, Books) using Excel formulas — specifically, the SUMIF function, as suggested by the file name.

---

✔ Goal:

Fill in the "Total Sale amount" column in the Item-wise table on the right using formulas based on the Date-wise table on the left.

---

🧠 Solution Using SUMIF Function

The `SUMIF` function in Excel adds up values that meet a specified condition.

#### Syntax:
```excel
=SUMIF(range, criteria, [sum_range])
```

- `range`: The column where we check the condition (e.g., "Name of Items")
- `criteria`: The item name we are looking for (e.g., "Pen")
- `sum_range`: The column with the amounts to sum (e.g., "Amount")

---

✔ Step-by-step Formula Application

Assuming the "Item wise total Sale Amount" table starts at cell H2, and the "Date wise Sale" data is in columns B to F:

| Item | Formula |
|-------------|--------|
| Pen | `=SUMIF(B4:B21, "Pen", F4:F21)` |
| Pencil | `=SUMIF(B4:B21, "Pencil", F4:F21)` |
| Sticker | `=SUMIF(B4:B21, "Sticker", F4:F21)` |
| Register | `=SUMIF(B4:B21, "Register", F4:F21)` |
| Books | `=SUMIF(B4:B21, "Books", F4:F21)` |

> Note: Rows 4 to 21 contain the actual sales data.

---

💡 Example: Calculating Total for "Pen"

Let’s verify the value for Pen:

From the table:
- 01-04-18: 500
- 06-04-18: 400
- 10-04-18: 50
- 14-04-18: 140
- 16-04-18: 100

Total = 500 + 400 + 50 + 140 + 100 = 1,190 ✔

So, formula in cell I4 (for Pen):
```excel
=SUMIF(B4:B21, "Pen", F4:F21)
```
Result: 1,190

Similarly:
- Pencil: 30 + 42 + 38 + 14 = 124
- Sticker: 10 + 20 + 100 + 125 + 10 + 55 = 320
- Register: 500 → 500
- Books: 1,500 + 600 = 2,100

Total of all items: 1,190 + 124 + 320 + 500 + 2,100 = 4,234 ✔ Matches bottom total.

---

✔ Final Answer:

Use the following SUMIF formulas in the Item-wise total Sale Amount table:

| Cell | Formula |
|------|---------|
| I4 | `=SUMIF(B4:B21, "Pen", F4:F21)` |
| I5 | `=SUMIF(B4:B21, "Pencil", F4:F21)` |
| I6 | `=SUMIF(B4:B21, "Sticker", F4:F21)` |
| I7 | `=SUMIF(B4:B21, "Register", F4:F21)` |
| I8 | `=SUMIF(B4:B21, "Books", F4:F21)` |

> You can also use relative references if you're copying down, but since the criteria are fixed, these are fine.

---

💡 Pro Tip:

To make it dynamic and avoid typos, you can reference the item names from column H:
For example, in I4:
```excel
=SUMIF($B$4:$B$21, H4, $F$4:$F$21)
```
Then drag down — this avoids hardcoding text and reduces errors.

---

✔ Summary:

You’ve successfully used the SUMIF function to compute item-wise total sales from date-wise data. This is a classic use case for conditional aggregation in Excel.

Let me know if you'd like a downloadable version or want to use Pivot Tables instead!