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

[@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

[@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.

[@madheshiarakes]

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

[@Innozant]

Thanks dear

[@class12commerce99]

You are a gem teacher sir... Ur explanation is exceptional... ❤

[@harindersingh-sc2wb]

your teaching skills are unbeatable

[@AJAYSINGH-ii1wm]

It's real help us to save time, thanks Sir

[@satishmestry5687]

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

[@Innozant]

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

[@balance1772]

Awesome Guruji...this one is awesome

[@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 👍

[@kkrcreationstatus6583]

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

[@Innozant]

❤️👍

[@rahulsaxena9090]

Sir aap bahut accha samjhate hain mind blowing sir

[@Innozant]

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

[@RAEES_Kaushar]

Pahili bar aap ne dimag hi hila dala❤❤

[@Innozant]

☺️

[@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

[@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

[@NavneetSingh-io4jh]

Thankyou Sir, you were amazing 😍🤩

[@born2fight77]

wah kya baat hai, you are superb

[@Innozant]

Thanks Arun ji

[@RohitKumar-cc7zi]

Good sir 😊😊 keep it up

[@Rejuanhaque]

Very helpful video Sir

[@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

[@Sanddystar17]

great sir..🙏 helpful knowledge 🌷

[@Innozant]

Thanks Sandeep 😊❤️🙏 Happy Learning,Keep sharing

[@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.

[@devendrakumarkewat8967]

Sir aap bahut mast batate hai .Thank you sir

[@Innozant]

Thanks dear

[@artiverma5122]

Sir you are fevolus 🙏👌

[@Innozant]

thanks Arti

[@rahulkumarsharma9533]

Super say vhi bahut upper Great sir

[@Innozant]

Thanks Rahul ❤️🙏😊

[@shahzadsiddiqui5117]

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

[@pritamaroy4276]

It is beneficial. Thank you sir

[@Innozant]

Thanks Pratima .Happy Learning ❤️

[@chiranjit90020]

Awesome sir. Thank you very much

[@Innozant]

❤️❤️❤️🙏🙏

[@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

[@anupamagarwal825]

Is it necessary to create seperate table to implement D functions ??

[@gauravbhatia7987]

Thnq sir je bhi bohat use kruga abb main

[@Innozant]

Thats Good Gaurav ♥️🙏

[@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.🙏😊❤️

[@MsExcelPakistan]

Very nice sir your videos

[@Innozant]

Thanks

[@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😊

[@iamsainipawan]

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.

[@2-minute-solution]

Nice explanation.

[@Innozant]

Thanks dear❤️

[@priyankadubey1220]

Good teaching sir

[@Innozant]

Thanks Priyanka.Happy Learning ♥️

[@Rahul.54]

Thank you so much sir

[@artiverma5122]

Super se upr ho aap

[@Innozant]

Thanks Arti

[@nirala5]

Thank so much this formula

[@Innozant]

Thanks Kunal for watching and start learning 🙏😊❤️

[@meditationmusic6482]

So good 😍 sir.

[@Innozant]

Thanks

[@Sasi_patidar]

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

[@Sasi_patidar]

Thanks 🙏🙏🙏🙏🙏🙏🙏

[@ajitsingh4736]

Nice👍👍

[@bikashkumarparida7595]

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

[@karankapoor200]

great sir 🙏👌🏻

[@Innozant]

Thanks Karan❤️😊🙏

[@vinayrsoni4334]

Great job Sir

[@Innozant]

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

[@p.kstudy3134]

जबरदस्त सर

[@Innozant]

Thanks PK 🙏❤️

[@dhruvtiwari6179]

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

[@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

[@anooparora2515]

Thanks Sir!

[@bhoopendraraghav9781]

Very Very Nice...

[@Innozant]

Thanks Bhoopendra Ji..God bless ayou dear

[@bhoopendraraghav9781]

@@Innozant always love u sir g...

[@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

[@Sasi_patidar]

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

[@Sasi_patidar]

Ok sir i am waiting your video with Passion 😉

[@naveensingh9695]

Mast 👍👍

[@Innozant]

Thanks

[@SatishKumar-jd5it]

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

[@Innozant]

Nhi dear

[@rupalimahulkar4548]

Thanks🙏🙏

[@Innozant]

Thanks Rupali

[@javedahmed8343]

D Function Simplicity makes the one choose it

[@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

[@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?

[@shwetkumar1719]

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

[@Innozant]

Haan Shwet iski limitations hain

[@shwetkumar1719]

@@Innozant ok sir

[@jigarsheth6359]

Thank you sir

[@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 के वर्क नही करता

[@iSonuGautam]

Amit = 2700 (while using DPRODUCT) Plz explain

[@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?

[@VikashKumar-mz9cm]

Sir revision series kis naam se hai playlist me

[@Innozant]

Proquest assignment series

[@VikashKumar-mz9cm]

@@Innozant Thank you sir

[@sudiptamanna4195]

VERY GOOD

[@Innozant]

Thanks Sudipta ❤️

[@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?

[@VimalKumar-ih6ik]

Graet Sir

[@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.

[@deepakdobhal4388]

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

[@ShoaibAkhtar-ir3ye]

Thank u sir

[@Innozant]

Thanks Akhtar sahab

[@RajChaturvedi11]

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

[@Innozant]

No we don't have

[@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

[@chandandasy2k10]

sir when will come excel revision series.

[@Innozant]

Soon ...

[@bollywoodmoviesshort7605]

Is sheet mai jo apne banai hai

[@roshanrajkumar816]

Nice sir

[@Innozant]

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

[@chandrashekar5621]

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

[@AmarjeetSingh-tu5fv]

Bahut sundar

[@Naseerkhankhel]

Good

[@tusharmali4797]

Thanks

[@Innozant]

Thanks

[@onesidelax7807]

Pdf milega kiya sir

[@bishtlokesh1297]

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

[@Innozant]

Yes..soon

[@supriyayadav8974]

Great

[@Innozant]

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

[@RamSingh-ol5xz]

Sir

[@RamSingh-ol5xz]

Nice

[@Innozant]

Thanks Ram,Learn and share with your friends.

[@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

[@chauhanofficial2004]

Exclent

[@Innozant]

Thanks dear ❤️

[@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❤️🙏

[@ashokdas2568]

Wow

[@ashokdas2568]

Thank you sir

[@sujatamahulkar8154]

👍

[@Innozant]

Thanks Sujata

[@bishtlokesh1297]

Same criteria all database formula

[@Innozant]

🙏❤️

[@bollywoodmoviesshort7605]

Sir kuch puchna

[@AnkitSingh-mh7ee]

Sir aapke pair chunne hain

[@Innozant]

God bless you

[@jasvirsingh-zq9ch]

Apne or confusion kr di

[@Innozant]

Kya confuse ho gye jasvir ji??

[@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..

[@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

[@rupalimahulkar4548]

Nice👍

[@parmeshsrivastava2389]

Thank you sirji

[@Innozant]

Thanks dear