How to Use SUMIF Formula in Excel - HINDI│SumIF Use With Example│SumIF Full Explanation in HINDI

SUMIF is a function to sum cells that meet a single criteria. SUMIF can be used to sum cells based on dates, numbers, and text that match specific criteria. SUMIF supports logical operators and wildcards (*,?) for partial matching.
As the name suggests SUMIF formulae are formed by combining SUM and IF functions. In simple English this implies that these functions can add the items or cells that fulfill a particular criteria.
You know SUM function has the capability to add items, and SUMIF function extends the capabilities of SUM function by giving you the choice to SUM only those items that meet a particular criteria.
Arguments
range - The range of cells that you want to apply the criteria against.
criteria - The criteria used to determine which cells to add.
sum_range - [optional] The cells to add together. If sum_range is omitted, the cells in range are added together instead.
At the same time SUMIFS function is a relatively newer function (introduced with Excel 2007) that extends the abilities of a SUMIF function by giving you the facility to add only those items that meet a set of criteria.
SUMIF Function in Excel:
According to Microsoft Excel SUMIF is defined as a function that “Adds the cells specified by a given condition or criteria”.
The Syntax of SUMIF Function is as under:
=SUMIF(range, criteria [, sum_range])
Here, ‘range’ refers to the cells that you want to be evaluated by the ‘criteria’.
‘criteria’ refers to the condition that specifies which items are to be added. ‘criteria’ can be a number, expression or a text string.
‘sum_range’ is an optional argument, it specifies the cells to be added. If ‘sum_range’ argument is omitted then SUMIF treats ‘range’ as ‘sum_range’.
Comtutor Excel Video, Plz watch Below Videos it will hepl you in excel.
Using Dollar ($) Sign in Excel Formula, Absolute and Relative Cell References Full Details in HINDI
• Using Dollar ($) Sign ...
How to Use Sum Function in EXCEL (4 Easy Methods) !! PART 4 !! in Hindi
• Sum Function in EXCEL ...
Excel SHORTCUTS Tutorial for Beginners in HINDI !! PART 3 !! Keyboard tricks
• Excel SHORTCUTS Tutori...
Formatting in MS-Excel For Beginners- !! Hindi PART 2 !! A Comprehensive Guide for Everyone
• Formatting in MS-Excel...
Basic MS-Excel Tutorial for Beginners- !! Hindi PART 1 !! A Comprehensive Guide for Everyone
• What is MS-Excel? Full...
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u

[@habeebmohammad8237]

please create videos for simple vba learning in Excel
thank you

[@ComTutor]

VBA is very huge topic, aur uske video bhi bade ho skte hai,
but agar mujhe Excel ki video par achcha response milta hai, and baki people bhi comment mei VBA ki demand karte hai to mai video jaroor banaounga.
thanks for your suggestion.

[@sohamggd6488]

Sir plz VBA Ka ek video create kijiye .

[@ComTutor]

okay mai VBA bhi jald hi sikhaounga.

[@sohamggd6488]

Waiting...