Sumif Formula in Excel Hindi

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