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.