👉SUMIF - Total SUM with Condition @Excel

SUMIF Excel ka ek powerful function hai jo kisi condition ke basis par numbers ka total (sum) nikalta hai.
👉 Matlab, aap pura data add nahi karte, sirf wahi values add hoti hain jo condition match karti hain.
🧠 Syntax:
Excel Formula
=SUMIF(range, criteria, sum_range)
📊 Example:
Agar aapke paas products aur sales ka data hai, aur aap sirf “Pen” ki total sales nikalna chahte ho:
Excel Formula
=SUMIF(A2:A7,"Pen",B2:B7)
👉 Result: Only “Pen” ki sales add hogi.
🎯 Use of SUMIF:
Specific item ki total sales nikalna
Category-wise sum calculate karna
Attendance / marks analysis
Financial reports me filtering with sum
🔥 Key Point:
👉 SUMIF = Condition + Sum
👉 Sirf matching data ka total deta hai

Видео 👉SUMIF - Total SUM with Condition @Excel канала Saini Excel Studio