Jinsi ya Kutumia SUMIFS (Sum with Multiple Conditions) kwenye Excel

SUMIFS function inakuwezesha kujumlisha namba kulingana na vigezo vingi (multiple conditions). Ni muhimu kwa budgeting, accounting, au data analysis unapohitaji kuongeza tu data inayokidhi criteria zote zilizowekwa.

🔹 Kutumia SUMIFS Function

Formula:

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Maelezo:

sum_range → Cells zinazojumlishwa

criteria_range1 → Cells zinazokaguliwa kwa sharti la kwanza

criteria1 → Sharti la kwanza

[criteria_range2, criteria2] → Sharti la pili na zaidi

Mfano:

Bidhaa Mauzo Mwezi
Apple 50 Jan
Banana 30 Jan
Apple 70 Feb
Apple 40 Jan

Formula:

=SUMIFS(B2:B5, A2:A5, "Apple", C2:C5, "Jan")

→ Matokeo: 90

Hapa, Excel inajumlisha mauzo ya Apple kwa mwezi wa Jan tu

🔹 Tips za Kutumia SUMIFS

Criteria inaweza kuwa text, numbers, logical expressions

Wildcards * na ? zinaweza kutumika kwa text: "App*"

SUMIFS inaweza changanywa na IF, ROUND, na logical functions kwa advanced calculations

Hakikisha sum_range na criteria_range zina dimension sawa, vinginevyo Excel itatoa error

📌 Resources & Links

Tazama tutorials zaidi za Excel: https://www.faulink.com

Download mifumo ya Excel bure: https://www.faulink.com/excel_mifumo.php

Msaada wa WhatsApp: https://wa.me/255693118509

✅ Hitimisho:
SUMIFS function ni muhimu kwa kujumlisha data kulingana na vigezo vingi. Kutumia SUMIFS kwenye Excel kunakuwezesha kufanya budgeting, sales reports, na data analysis kwa haraka, usahihi, na kwa ufanisi.