SUMIF Formula in excel | advanced excel tutorial #excel #exceltips #exceltutorial

SUMIF Formula in excel | advanced excel tutorial #excel #exceltips #exceltutorial

How to Use SUMIF Function in Microsoft Excel.

In this video, I explain the function of SUMIF in Microsoft Excel.

What is the SUMIF Function in Microsoft Excel?
The SUMIF function in Microsoft Excel allows you to calculate the sum of values within a range of cells that meet a specific criteria, essentially letting you add up only the cells that match a certain condition you define.

Syntax:
SUMIF(range, criteria, [sum_range])
range (Required): The range of cells that you want evaluated by criteria.
criteria (Required): The criteria in the form of a number, expression, a cell reference, text, or a function that defines which cells will be added.
sum_range (Optional): The actual cells to add, if you want to add cells other than those specified in the range argument.

Formula in this video:
=SUMIF(B3:B11,A13,C3:C11)

Thank you for watching my video. I hope to see you again in my next video.
If you have any questions please write in the comment below.
❤️❤️?❤️❤️
————————————————
#msexcel #pivottable #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #shortvideo #shortfeed #short #shorts #shortsviral #shortsyoutube #share #knowledge #knowledgesharing #exceleasy #excelformula #exceleducation #excelknowledge #microsoftoffice #newvideo #newexcel
@RachanaChiv
————————————————
Prepared by: Dr. Rachana Chiv

Close Menu