Άθροισμα πωλήσεων ανά πελάτη – SUMIF – Excel

Sum of Sales per Customer / Άθροισμα πωλήσεων ανά πελάτη

How the SUMIF Function Works (With Screenshot Callouts)

The SUMIF function in Excel lets you add values that meet a specific condition.
In this example, it is used to calculate the total sales per customer.

📌 Callout 1: The Raw Data (Left Side of the Image)

👉 Look at the left side of the screenshot

• Column A shows Customer names

• Column B shows Sales amounts

• Some customers appear multiple times, because they made more than one purchase

This is typical sales data that is not yet summarized.

📌 Callout 2: The Summary Table (Highlighted in Red)

👉 Look at the red highlighted area in the screenshot

This section shows:

• One row per customer

• The total sales amount for each customer

This is the result we want to calculate automatically using Excel.

📌 Callout 3: The SUMIF Formula (Right Side, Yellow Cells)

👉 Look at the yellow cells on the right

The formula used is:

=SUMIF($A$5:$A$14, C5, $B$5:$B$14)

Let’s understand each part:

• $A$5:$A$14
  The range Excel checks for customer names (criteria range)

• C5
  The customer name Excel is looking for

• $B$5:$B$14
  The range containing the sales values to be added

The dollar signs ($) make the ranges absolute so the formula works correctly when copied down.

📌 Callout 4: What Excel Does Step by Step

👉 Behind the scenes, Excel does the following:

1. Scans all customer names in column A

2. Compares each name with the customer in column C

3. When a match is found, Excel selects the corresponding sales value from column B

4. All matching values are added together

📌 Callout 5: Final Result

👉 Look again at the red highlighted summary table

• Each customer appears only once

• The total sales are calculated automatically

• Copying the formula down instantly calculates totals for all customers

✅ When SUMIF Is Useful

SUMIF is ideal when you want to:

• Calculate sales per customer

• Add values based on one condition

• Create summaries without using pivot tables

It is one of the most important Excel functions for basic reporting and data analysis.

#excel_tips #excel_calculations #softexperia / www.softexperia.com