Jinsi ya Kutumia SUMIF (Sum with One Condition) kwenye Excel

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.