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.