Database Functions (DSUM , DAVERAGE , DCOUNT , DMAX , DMIN , DPRODUCT)

Database Functions (DSUM , DAVERAGE , DCOUNT , DMAX , DMIN , DPRODUCT)
Learn powerful Database functions in one video. Advantage of DSUM formula in hindi over SumIF Function.if you do not have xlookup in your excel there is no need to worry, you can learn DGET formula and it is great substitute of Vlookup & Index Function even in some aspect Database function is much better than lookup.
Download the Practice Workbook Direct Link here-drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Basic Excel-Database Function-DatabaseFunctions.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#databasefunction#dsumformula#Innozant #exceldatabasefunction

[@javedahmed8343]

Your comparative study makes one choose the right function. What a deep insight of the excel u have! Thanks

[@user-jc6te1vm8v]

more i see you teaching more i like ur way of teaching.... u r making excel a childs play... thnku sir

[@Innozant]

Thanks my dear friend for such a lovely appreciation.Will always try to motivate all of you and give you dose of Success everyday

[@madheshiarakes]

Sir....I like your teaching method
You cleared the concept
There are no doubt about this function
Thankyou Sir🙏🙏🙏

[@Innozant]

Thanks dear

[@sandeepaswal8944]

Sir I appreciate the lessons and I learn too much things from you.Your teaching method is unparallel. The most valuable thing. You reply to all comments.you are very different to all excel youtuber.

[@Innozant]

Thanks Sandeep for your appreciation.Offcoure I am teacher by profession not business person 🙏😊,Will always try to give reply.Thanks for your support.Keep watching and share with your friend to learn.

[@FaizanKhan-ts2lm]

I am writing again because Basic Excel playlist is very useful for me. I wish that I could found this channel earlier.

[@Innozant]

Thanks Dear.Keep Exploring

[@satishmestry5687]

Sir, your teaching method is incredible.
Thank you so much Sir......!!

[@Innozant]

Thanks Satish ji..for your lovely feedback 🙏❤️

[@harindersingh-sc2wb]

your teaching skills are unbeatable

[@rahulsaxena9090]

Sir aap bahut accha samjhate hain mind blowing sir

[@Innozant]

Thanks Saxena ji..God bless You..achese Seekhiye aur aage badhiye life me

[@devendrakumarkewat8967]

Sir aap bahut mast batate hai .Thank you sir

[@Innozant]

Thanks dear

[@RAEES_Kaushar]

Pahili bar aap ne dimag hi hila dala❤❤

[@Innozant]

☺️

[@balance1772]

Awesome Guruji...this one is awesome

[@kkrcreationstatus6583]

Sir....One to One Surprise dete rahiye isi tarah...Aapko "PRANAM",

[@Innozant]

❤️👍

[@born2fight77]

wah kya baat hai, you are superb

[@Innozant]

Thanks Arun ji

[@vanshikasuri7146]

sir , thnxx allot for this video , i am regularly watching ur videos . i have learnt new things from ur videos thnxxx allot sir......

[@Innozant]

Thanks Vanshika for being part Of Inny Family,We welcome you to experience the taste of success dear ❤️🙏
Recommend you to finish Basic Excel Playlist first followed by Sort & Filter ,Data validation,What if Analysis, array,vlookup ,pivot & Dashboard 👍

[@Rahul.54]

Thank you so much sir

[@shahzadsiddiqui5117]

Sahi function hai , use kr skte isko bhi...!

[@RohitKumar-cc7zi]

Good sir 😊😊 keep it up

[@NavneetSingh-io4jh]

Thankyou Sir, you were amazing 😍🤩

[@hemantgusain1260]

Thanks you sir, actually I leared this topic earlier but you cleared all my doubts regarding this topic.

[@Innozant]

Thanks Hemant..DGET ka best advantage over vlookup and index..bht jald Video apke liye.😊❤️🙏

[@hemantgusain1260]

@@Innozant thanks you sir.

[@anooparora2515]

Thanks Sir!

[@nirala5]

Thank so much this formula

[@Innozant]

Thanks Kunal for watching and start learning 🙏😊❤️

[@vready4all]

Sir, Good Evening, I am regularly watching your videos. I have learnt new things from your videos. Thank you very much for your efforts as well enthusiasm to teach us.

[@Innozant]

Thanks Venkat,Hope you like the training methodology and able to understand the concept,Learn step by step, Assignment are there I'm description. God bless you.Have a blooming career ahead🙏❤️❤️

[@vready4all]

@@Innozant Thank you Sir

[@gauravbhatia7987]

Thnq sir je bhi bohat use kruga abb main

[@Innozant]

Thats Good Gaurav ♥️🙏

[@anoopchaudhary8893]

waah sir waah maza aa gya!!
single criteria me to sumif sahi hai, par bat jab multiple criteria ki ho to Dsum jyada better hai. nestedif ki jagah Vlookup yaad aa gya.☺️
#Innozant

[@Innozant]

Very true but maine Dsum ka negative point bhi btaya hai uska bhi dhyan rakhen tabhi Sumit hi jyada use hota hai

[@MsExcelPakistan]

Very nice sir your videos

[@Innozant]

Thanks

[@jigarsheth6359]

Thank you sir

[@javedahmed8343]

D Function Simplicity makes the one choose it

[@Rejuanhaque]

Very helpful video Sir

[@2-minute-solution]

Nice explanation.

[@Innozant]

Thanks dear❤️

[@shubhangshukla3179]

Thankyou sir

[@priyankadubey1220]

Good teaching sir

[@Innozant]

Thanks Priyanka.Happy Learning ♥️

[@pritamaroy4276]

It is beneficial. Thank you sir

[@Innozant]

Thanks Pratima .Happy Learning ❤️

[@rahulkumarsharma9533]

Super say vhi bahut upper
Great sir

[@Innozant]

Thanks Rahul ❤️🙏😊

[@chiranjit90020]

Awesome sir. Thank you very much

[@Innozant]

❤️❤️❤️🙏🙏

[@artiverma5122]

Super se upr ho aap

[@Innozant]

Thanks Arti

[@parmeshsrivastava2389]

Thank you sirji

[@Innozant]

Thanks dear

[@artiverma5122]

Sir you are fevolus 🙏👌

[@Innozant]

thanks Arti

[@Sanddystar17]

great sir..🙏 helpful knowledge 🌷

[@Innozant]

Thanks Sandeep 😊❤️🙏 Happy Learning,Keep sharing

[@p.kstudy3134]

जबरदस्त सर

[@Innozant]

Thanks PK 🙏❤️

[@rupalimahulkar4548]

Thanks🙏🙏

[@Innozant]

Thanks Rupali

[@ajitsingh4736]

Nice👍👍

[@puneetsingh2801]

sir your style of teaching is amazing plz sir make videos on SQl if you can

[@Innozant]

Thanks Puneet ji..Will make videos on sql for sure

[@puneetsingh2801]

@@Innozant thanks sir i m eagerly waiting for it😊

[@satishojha6240]

Hello sir cahey Jo bhi database ho Hume koshish karni chahiye ki hum kaise cum space mai kaam karey. It is unique concept keep it up good night sir.thanku

[@Innozant]

Bikul sahi Satish optimization sabse important hota hai..kaam to sabko karna aata hai .but optimized approach matter.🙏😊❤️

[@VimalKumar-ih6ik]

Graet Sir

[@bhoopendraraghav9781]

Very Very Nice...

[@Innozant]

Thanks Bhoopendra Ji..God bless ayou dear

[@bhoopendraraghav9781]

@@Innozant always love u sir g...

[@tusharmali4797]

Thanks

[@Innozant]

Thanks

[@impawansaini08]

Hi sir aajkal Google sheets in very demand uspar video tutorial banaye kyunki sir aap acchese described karte ho topics ko🙏❤️sir

[@Innozant]

Bht jald dear.

[@sudiptamanna4195]

VERY GOOD

[@Innozant]

Thanks Sudipta ❤️

[@vinayrsoni4334]

Great job Sir

[@Innozant]

Thanks Vinay🙏❤️Keep watching,Learn and share with your friends.

[@shafiqueansari7728]

Sir ap ka parhane ka style bhoat acha hai.
Sir mujhe is me ek problem a rahi hai me agar Drage down kar raha haun to top value me total a raha hai niche wali value me error

[@meditationmusic6482]

So good 😍 sir.

[@Innozant]

Thanks

[@naveensingh9695]

Mast 👍👍

[@Innozant]

Thanks

[@gagnendranigam7013]

Nice

[@ashokdas2568]

Wow

[@ashokdas2568]

Thank you sir

[@karankapoor200]

great sir 🙏👌🏻

[@Innozant]

Thanks Karan❤️😊🙏

[@Naseerkhankhel]

Good

[@supriyayadav8974]

Great

[@Innozant]

Thanks Supriya, Welcome you to experience the taste of Success.Happy Learning 🙏

[@roshanrajkumar816]

Nice sir

[@Innozant]

Thanks Roshan,We welcome you to experience the taste of success.Learn-Enhance skills-Succussful career.

[@naeemulhassan1426]

Sir. It is requested to you plz breaf week day function and work day function in very details .when should use week day function and when use work day function in very details. It is more requested you kindly breaf it that which work in which window or not exist in that window. Awaiting your reply plz. Regards

[@riyazhhakim3324]

Hi, I have seen lot of videos of yours and it really helps. I am currently working as MIS Executive and would like to learn power pivot, power query and other advanced functions. Request you to share course details if you have any.
Regards,
Riyaz

[@Innozant]

Thanks for showing your interest,For more info kindly contact us directly, Contact details provided on innozant website

[@riyazhhakim3324]

Sure..... Thanks

[@cristal5921]

@@riyazhhakim3324 hlo

[@sujatamahulkar8154]

👍

[@Innozant]

Thanks Sujata

[@chauhanofficial2004]

Exclent

[@Innozant]

Thanks dear ❤️

[@AmarjeetSingh-tu5fv]

Bahut sundar

[@dhruvtiwari6179]

Sir can we use wildcard alongwith with these d functions and can you help me how we can use it

[@RamSingh-ol5xz]

Sir

[@pramodbhatt6906]

Sir, In Database function can we get the output for one name only if i want to get the output of two names what to do?

[@samimsedeqey8231]

Hello, sir I am one of your subscribers . Sir but what if we have similar item names in our item list like mouse, mouse pad etc when is use DSUM function it sums the total of both mouse and mouse pad . How to solve this problem please?

[@SatishKumar-jd5it]

sir dsum me bhi formula drag nhi ksr sakte na dget ki tarah ????

[@Innozant]

Nhi dear

[@iSonuGautam]

Amit = 2700 (while using DPRODUCT) Plz explain

[@Sasipatidar]

Sir mere 4 doubt he
1 Dsum function sum if or sumifs ka kam karta hein.
2 Dmax function max ifs ka kam karta he
3 D min, min ifs ka bhi kam krta he kya
4 D count , count if or count ifs ka bhi kam karta he

[@Innozant]

Criteria based saare function ke jagah laga sakt hain

[@Sasipatidar]

Thanks 🙏🙏🙏🙏🙏🙏🙏

[@pramodbhatt6906]

Hi Sir, In DSUM if im trying to get the value of Sony as well with same criteria my output comes wrong

[@pramodbhatt6906]

Ouput comes same as Nokia

[@pramodbhatt6906]

What should be select as a criteria?

[@deepakdobhal4388]

Sir, Do wild cards work with database Dcount or Dcounta?

[@anupamroy1455]

sir your videos are too good but the link to the practice workbook file is not working please have a look at it.......

[@Innozant]

Hi Anupam direct link is broken now but assignment master link is working fine

[@mohiuddinchoudhury1145]

Sir, dcount() 0 ko bhi as a number pakad let Hain. Uska Kya solution ho sekta?

[@Innozant]

haan count kr lega 0 use..aap chahte kya hain ye btaiye phir deta hu solution

[@mohiuddinchoudhury1145]

@@Innozant Sir data table mein see no. of pending amount nikal na tha, customer name ke upar base korke. Par pending amount column mein baki no. Ki tarah 0 bhi tha.
Tho Sir 0 pakad ne see galat ho jaiga na? Muje 0 ko nehi Lena tha.

[@badgujardnyaneshwar]

सर लेकिन ये एक से ज्यादा row में निकलना है तो फिर इसमें दिक्कत होता है
क्योंकि ये बिना header के वर्क नही करता

[@Sasipatidar]

sir aapne es video me bola he ki app Excel revisions series bhi layenge or Excel revisions series mil nahi Rahi aapke channel par

[@Innozant]

Proquest Series dear

[@Sasipatidar]

Ok sir i am waiting your video with Passion 😉

[@kishorpanara4191]

Sir mera kahena galat nahi hai ke aap excel magician ho kyo ki mene abhi tak " d " function wala video dekha nahi hai

[@Innozant]

Kishore ji Mera bhi wada hai ye magic show apko Daily dekhne ko milta rhega.. Happy Learning and share with your friends to learn.

[@shwetkumar1719]

Sir esme ek bar me sirf "ek field" ko select kr sakte hai?

[@Innozant]

Haan Shwet iski limitations hain

[@shwetkumar1719]

@@Innozant ok sir

[@bishtlokesh1297]

DGET DVAR, DVARP, DSTDAV, yeah bhi le aana sir

[@Innozant]

Yes..soon

[@VikashKumar-mz9cm]

Sir revision series kis naam se hai playlist me

[@Innozant]

Proquest assignment series

[@VikashKumar-mz9cm]

@@Innozant Thank you sir

[@bollywoodmoviesshort7605]

Is sheet mai jo apne banai hai

[@chandandasy2k10]

sir when will come excel revision series.

[@Innozant]

Soon ...

[@mohdaqibsiddiqui1462]

App mis ka full course kraoge sir

[@Innozant]

Offcourse,Aap Dekh Rahe hinge Jaise video upload ho Raha hai Excel Ka so demo video nhi hai dear,Complete Course step by step Kara rhe Hain online available ,Jo students fees nhi kar skate hain afford unke liye Free course mile step by step.,Aage Kai saare playlist upload honge

[@onesidelax7807]

Pdf milega kiya sir

[@RajChaturvedi11]

Sir mujhe dca pro ka pura notes chaiye milega kya in hindi

[@Innozant]

No we don't have

[@chandrashekar5621]

Sir mein na same trick use Kiya fir bhi answer is 0

[@bishtlokesh1297]

Same criteria all database formula

[@Innozant]

🙏❤️

[@jasvirsingh-zq9ch]

Apne or confusion kr di

[@Innozant]

Kya confuse ho gye jasvir ji??

[@bollywoodmoviesshort7605]

Sir kuch puchna

[@RajChaturvedi11]

Sir mujhe dca pro ka pura notes chaiye in Hindi

[@Innozant]

Nhi hai humare paas .DCA nhi karate hain .. Industrial training karate hain dear

[@AnkitSingh-mh7ee]

Sir aapke pair chunne hain

[@Innozant]

God bless you

[@kritigupta2993]

If I have to find East OR west together then how it can be done?

[@Innozant]

Limitation of database function..we can do with vlookup easily❤️🙏

[@saintxavier8178]

Apni photo chhoti karo yaar.

[@Innozant]

👍

[@SushilChauhan]

abe tu screen ke uppar kyun baitha hai

[@Innozant]

Sushil ji aise hi language aap apne teacher aur parents ke liye use karte hain.?Great dear👍koi educated insaan aise language kaise bhala use kar skta hai..

[@bikashkumarparida7595]

SIR , WHEN I USE SUM(IFS) INSTEAD OF DSUM ,,,,I GOT DIFFERNET VALUES

[@rupalimahulkar4548]

Nice👍

[@ShoaibAkhtar-ir3ye]

Thank u sir

[@Innozant]

Thanks Akhtar sahab

[@shafiqueansari7728]

Sir ap ka parhane ka style bhoat acha hai.
Sir mujhe is me ek problem a rahi hai me agar Drage down kar raha haun to top value me total a raha hai niche wali value me error

[@RamSingh-ol5xz]

Nice

[@Innozant]

Thanks Ram,Learn and share with your friends.