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

[@class12commerce99]

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

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

[@rahulsaxena9090]

Sir aap bahut accha samjhate hain mind blowing sir

[@Innozant]

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

[@harindersingh-sc2wb]

your teaching skills are unbeatable

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

[@RAEES_Kaushar]

Pahili bar aap ne dimag hi hila dala❤❤

[@Innozant]

☺️

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

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

[@devendrakumarkewat8967]

Sir aap bahut mast batate hai .Thank you sir

[@Innozant]

Thanks dear

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

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

[@NavneetSingh-io4jh]

Thankyou Sir, you were amazing 😍🤩

[@shahzadsiddiqui5117]

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

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

[@Rejuanhaque]

Very helpful video Sir

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

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

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

[@Rahul.54]

Thank you so much sir

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

[@pritamaroy4276]

It is beneficial. Thank you sir

[@Innozant]

Thanks Pratima .Happy Learning ❤️

[@chiranjit90020]

Awesome sir. Thank you very much

[@Innozant]

❤️❤️❤️🙏🙏

[@rahulkumarsharma9533]

Super say vhi bahut upper Great sir

[@Innozant]

Thanks Rahul ❤️🙏😊

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

[@nirala5]

Thank so much this formula

[@Innozant]

Thanks Kunal for watching and start learning 🙏😊❤️

[@MsExcelPakistan]

Very nice sir your videos

[@Innozant]

Thanks

[@jigarsheth6359]

Thank you sir

[@anooparora2515]

Thanks Sir!

[@dhruvtiwari6179]

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

[@artiverma5122]

Sir you are fevolus 🙏👌

[@Innozant]

thanks Arti

[@Sanddystar17]

great sir..🙏 helpful knowledge 🌷

[@Innozant]

Thanks Sandeep 😊❤️🙏 Happy Learning,Keep sharing

[@RohitKumar-cc7zi]

Good sir 😊😊 keep it up

[@2-minute-solution]

Nice explanation.

[@Innozant]

Thanks dear❤️

[@bikashkumarparida7595]

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

[@priyankadubey1220]

Good teaching sir

[@Innozant]

Thanks Priyanka.Happy Learning ♥️

[@shubhangshukla3179]

Thankyou sir

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

[@artiverma5122]

Super se upr ho aap

[@Innozant]

Thanks Arti

[@javedahmed8343]

D Function Simplicity makes the one choose it

[@OwnSkillPc]

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

[@OwnSkillPc]

Thanks 🙏🙏🙏🙏🙏🙏🙏

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

[@rupalimahulkar4548]

Thanks🙏🙏

[@Innozant]

Thanks Rupali

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

[@SatishKumar-jd5it]

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

[@Innozant]

Nhi dear

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

[@shwetkumar1719]

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

[@Innozant]

Haan Shwet iski limitations hain

[@shwetkumar1719]

@@Innozant ok sir

[@bhoopendraraghav9781]

Very Very Nice...

[@Innozant]

Thanks Bhoopendra Ji..God bless ayou dear

[@bhoopendraraghav9781]

@@Innozant always love u sir g...

[@tusharmali4797]

Thanks

[@Innozant]

Thanks

[@meditationmusic6482]

So good 😍 sir.

[@Innozant]

Thanks

[@p.kstudy3134]

जबरदस्त सर

[@Innozant]

Thanks PK 🙏❤️

[@vinayrsoni4334]

Great job Sir

[@Innozant]

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

[@OwnSkillPc]

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

[@OwnSkillPc]

Ok sir i am waiting your video with Passion 😉

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

[@VikashKumar-mz9cm]

Sir revision series kis naam se hai playlist me

[@Innozant]

Proquest assignment series

[@VikashKumar-mz9cm]

@@Innozant Thank you sir

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

[@ajitsingh4736]

Nice👍👍

[@sudiptamanna4195]

VERY GOOD

[@Innozant]

Thanks Sudipta ❤️

[@karankapoor200]

great sir 🙏👌🏻

[@Innozant]

Thanks Karan❤️😊🙏

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

[@VimalKumar-ih6ik]

Graet Sir

[@roshanrajkumar816]

Nice sir

[@Innozant]

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

[@badgujardnyaneshwar]

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

[@naveensingh9695]

Mast 👍👍

[@Innozant]

Thanks

[@gagnendranigam7013]

Nice

[@iSonuGautam]

Amit = 2700 (while using DPRODUCT) Plz explain

[@AmarjeetSingh-tu5fv]

Bahut sundar

[@supriyayadav8974]

Great

[@Innozant]

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

[@chandandasy2k10]

sir when will come excel revision series.

[@Innozant]

Soon ...

[@RajChaturvedi11]

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

[@Innozant]

No we don't have

[@bollywoodmoviesshort7605]

Is sheet mai jo apne banai hai

[@Naseerkhankhel]

Good

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

[@chandrashekar5621]

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

[@onesidelax7807]

Pdf milega kiya 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.

[@ashokdas2568]

Wow

[@ashokdas2568]

Thank you sir

[@chauhanofficial2004]

Exclent

[@Innozant]

Thanks dear ❤️

[@RamSingh-ol5xz]

Sir

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

[@sujatamahulkar8154]

👍

[@Innozant]

Thanks Sujata

[@bishtlokesh1297]

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

[@Innozant]

Yes..soon

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

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

[@parmeshsrivastava2389]

Thank you sirji

[@Innozant]

Thanks dear

[@ShoaibAkhtar-ir3ye]

Thank u sir

[@Innozant]

Thanks Akhtar sahab

[@rupalimahulkar4548]

Nice👍

[@RamSingh-ol5xz]

Nice

[@Innozant]

Thanks Ram,Learn and share with your friends.