SUMIF function inakuwezesha kujumlisha namba ndani ya range kulingana na sharti moja. Ni muhimu kwa budgeting, accounting, au data analysis ambapo unataka kuongeza tu data inayokidhi criteria fulani.
🔹 Kutumia SUMIF Function
Formula:
=SUMIF(range, criteria, [sum_range])
Maelezo:
range → Cells zinazokaguliwa kwa sharti
criteria → Sharti la kuchagua cells (">100", "Apple")
sum_range → Cells zinazojumlishwa ikiwa zinakidhi sharti
Mfano:
Bidhaa Mauzo
Apple 50
Banana 30
Apple 70
Formula: =SUMIF(A2:A4,"Apple",B2:B4) → Matokeo: 120
Hapa, Excel inajumlisha mauzo ya Apple tu
🔹 Tips za Kutumia SUMIF
Criteria inaweza kuwa namba, text, au logical expression
Tumia * kama wildcard kwa text: "App*" inajumuisha "Apple" na "Application"
SUMIF inaweza changanywa na IF, ROUND, na logical functions kwa advanced calculations
📌 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:
SUMIF function ni muhimu kwa kujumlisha data kulingana na sharti fulani. Kutumia SUMIF kwenye Excel kunakuwezesha kufanya budgeting, sales reports, na data analysis kwa haraka na usahihi.