How To Apply SUMIF and COUNTIF formula on Large / Big Data in Excel (Hindi)
How To Apply SUMIF and COUNTIF formula on Large / Big Data in Excel (Hindi)
dosto Microsoft excel main sumif and countif formula ko bade data par kaise apply karange ye is video me maine dikhaya hai.. agar apko sumif or countif function apply karna nahi aata to ye video apke liye bahut kaam ka hai kyun ki is video se aap excel me sumif & countif formula lagana seekh jayenge. is video me maine 10,000 records par sumif and countif functions ko apply kiya hai sath hi kuch special tips and tricks bhi share ki hain. #excelformulas #excelformulasandfunctions #deepakeduworld
Sumif Function - basic sum formula se hum kisi bhi range ka sum kar saktey hain but agar hume conditional sum karna ho to vahan par use kartey hain sumif formula
Countif Function - agar hume kisi range me koi special criteria count karna ho to vahan par use kartey hain countif formula. video me step by step sab kuch bataya gaya hai
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Download Training File : bit.ly/3Wgm7FJ
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld
Пікірлер: 27
You can download TRAINING FILE from video description ✅ Link is given ✅
@mirzafurquan3576
24 күн бұрын
How to apply Vlookup in Duplicate.
@poojapanchal9597
23 күн бұрын
Noida or Delhi Mai koi institutions hai apka
Thank you very much for this video. Please make a video on SUMIFS & COUNTIFS in large data.
First first first😅
Indebted to your vidoes for increasing productivity in my daily TASK Love from Pakistan
Bahut hi khub.. Bahut ache se samjaye hai aap.. Bahut hi asan Bhasa me... Aur Sumifs ka Function ap ne inventory mansen karne vale Vedio me samja chuke hai Hala k ye function aap ne Bahut pahele k Vedio me samjaya hai.. Is k wajah se mene stock management ka File bhi Ready kiya huva hai. Macro ko use kar k.. Jo aap ne Bahut pahele Samja chuke the. Mene aap k File dhundh kar nikala tha... But ye wala bhi aap ne pahele hi samja chuke the par dubara se aap ne sjaye achha laga... Very nice Vedio....❤
Very nice. Thanks for adding to my knowledge.
Sir, Access pe aik complete video banayen.🙏
2nd from Pakistan 🇵🇰 ❤
Excellent. Nicely explained. 👍
Good sir Sir AK video bna dy filter kya howa deta filter keya howi jaga kis trha sa paste kary gy
Yes
Thankful
❤❤❤ ek naya video banaye sir countifs and sumifs ka naya andaz me❤❤❤
👌 Sir
Nice
Sumifs, count ifs video chaiye pls
Sir ji sumifs with vlookup sath ek video banaye
Innovative ❤
Sir sumifs or countifs ka b bta dy from Karachi Pakistan
stdole32.tlb is problem ko kaise thik kre aap btao na please sir
Sir 2007 excel table likhna pr column show nhi kr rha or wps sheet ma bhi
Ek cell me no. Or uske percent ko kaise likh sakte hai?? Ex. 3219 (80%)
Sir, 🙏A compulsory college education certificate is needed to learn data analysis.🙏
Xlookup nahi ho raha ha Sir please help
Countif= "Sales" how to put it