How To Apply SUMIF and COUNTIF formula on Large / Big Data in Excel (Hindi)
HTML-код
- Опубликовано: 21 авг 2024
- 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
You can download TRAINING FILE from video description ✅ Link is given ✅
How to apply Vlookup in Duplicate.
Noida or Delhi Mai koi institutions hai apka
Bohat achha sikhateo ap, (Sumifs & Countifs)plz.
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.
First first first😅
2nd from Pakistan 🇵🇰 ❤
Inventory management system in Excel pr Full video banao 🙏 for industrial use
Excellent. Nicely explained. 👍
Thank you very much for this video. Please make a video on SUMIFS & COUNTIFS in large data.
Yes
Thankful
Nice
👌 Sir
❤❤❤ ek naya video banaye sir countifs and sumifs ka naya andaz me❤❤❤
Good sir
Sir AK video bna dy filter kya howa deta filter keya howi jaga kis trha sa paste kary gy
Sumifs, count ifs video chaiye pls
Sir, Access pe aik complete video banayen.🙏
Innovative ❤
Sir ji sumifs with vlookup sath ek video banaye
Sir sumifs or countifs ka b bta dy from Karachi Pakistan
Please make new video for sumifs and countifs
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.🙏
Sir, if i right two dates, for example 19-08-2006 to 31-12-2023, now i want to get only 1 July and 1 December of each year from 2006 to 2023, how can i get? Plz healp.
31-12-2006
01-07-2007
31-12-2007
01-08-2008
31-12-2008
And onwards till 1-12-2023, in same row , horizontally sequence
Xlookup nahi ho raha ha Sir please help
Countif= "Sales" how to put it