Sumif Formula in Excel Hindi

2,301 views · Published 14 February 2018 · 5:36 · Indexed 4 November 2026

Channel: My E-Lesson · 2018 · Education

Watch on YouTube

100 लोगों में से 1 का डाटा टोटल करना हों तो यह फार्मूला लगाये . Excel हिंदी में Sumifफार्मूला का उपयोग करके विशिष्ट मानदंडों के आधार पर एक सीमा के योग की गणना करें।
Excel में SUMIF फॉर्मूला एक वर्कशीट फ़ंक्शन है जो एक मापदंड के आधार पर सभी संख्याओं को जोड़ता है (उदाहरण के लिए, 5000 के बराबर है)।

Calculate the the Sum of a range based on a specific criteria using the   Sumif formula in Excel Hindi. 
The SUMIF Formula in Excel is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 5000).

Learn the Sumif formula to do additions based on a condition.
Parameters or Arguments of Sumif Formula 

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. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range.
The worksheet shown in the video is available for free download at http://www.myelesson.org

Share your views and provide comments on the video so that I can improve the learning experience.

To watch more videos and download the files visit http://www.myelesson.org
To Buy The  Full Excel Course visit . http://www.myelesson.org/product    or call 9752003788
Connect with us on Facebook - https://www.facebook.com/excelmadeasy/
Connect with us on Twitter - https://twitter.com/Excelmadeasy 10 Most Used Formulas MS Excel
https://www.youtube.com/watch?v=KyMj8HEBNAk

Learn Basic Excel Skills For Beginners || Part 1
https://www.youtube.com/watch?v=3kNEv3s8TuA

10 Most Used Excel Formula 
https://www.youtube.com/watch?v=2t3FDi98GBk
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel
https://www.youtube.com/watch?v=vomClevScJQ

5 Excel Questions Asked in Job Interviews
https://www.youtube.com/watch?v=7Iwx4AMdij8

Create Speedometer Chart In Excel
https://www.youtube.com/watch?v=f6c93-fQlCs

Learn the Basic of Excel for Beginners || Part 2
https://www.youtube.com/watch?v=qeMSV9T1PoI

Create Pareto Chart In Excel
https://www.youtube.com/watch?v=2UdajrDMjRE

How to Create Dashboard in Excel 
https://www.youtube.com/watch?v=RM8T1eYBjQY

Excel Interview Questions & Answers
https://www.youtube.com/watch?v=Zjv1If63nGU

More from this channel