SUMIFS Function Made Simple | Excel Short Tutorial #shorts #shortsfeed #viral

Want to find total sales by city or category in Excel?
In this quick tutorial, you’ll learn how to use the SUMIFS function, one of Excel’s most powerful tools for conditional summing.

We’ll use a real example with sales data to show how you can calculate total sales per city automatically — step by step:

👉 Syntax:
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

👉 Example used:
=SUMIFS(C:C,D:D,F2,B:B,G2)
Here:

C2:C18 → Sales column (sum range)

D2:D18 → City column (criteria range)

B2:B18 → Name column (criteria range1)

G2 → Name (criteria1)

G2 → City name (criteria)

💡 Perfect for beginners learning Excel formulas for data analysis, reporting, or dashboards.

If you found this helpful, don’t forget to like 👍, comment 💬, and subscribe 🔔 to Skill Sigma Academy for more Excel tips and DMAIC tutorials!

Видео SUMIFS Function Made Simple | Excel Short Tutorial #shorts #shortsfeed #viral канала SkillSigma Academy