Excel Array Formula : Constructing Array with Condition | in Hindi

[@skflo3423]

you are the only one teacher i found on you tube who teaches from inside heart , So you can Proud to be Yourself .............

[@Innozant]

Thanks dear ,Allen ye words mere life me Sachme bahut mayne Rakhte hain dear ,aur apka ye pyar aur umeed main humesha kayam rakhne ki koshish krunga ❤🙏

[@madhavirathore4926]

👍👍👍

[@shivshankardksnr2572]

sir, you are a genius i learn lot from your videos.

[@sandeepaswal8944]

सर बहुत ही बेहतरीन तरीके से आपने आज कुछ नया सिखाया | आप बहुत ही अच्छा ज्ञान प्रदान करते हो सर जी |

[@subhank42]

Because of your teaching classes I improved in my professional life, this credit goes to you Thank you very much my youtube teacher 🙏👍

[@Innozant]

Thanks Shubham.Happy learning..God bless You

[@umairzahid3743]

Sir apka sab sy acha tareeqa Hai smajhany ka aik aik cheez ap bohat khubsorat treeqy sy bataty hain. You are great sir.

[@Innozant]

Thanks Umair sahab ❤️🙏

[@dipak5651]

Jabardast explanation and it shows that you can think to such an extent where even computer can't think. 😮

[@Innozant]

Thanks.Really meqns a lot to me

[@virendrahardiya2797]

Wao sir, ये तरीका बहुत मज़ेदार है,🙏👍👏👏👏👏👏👏🎈🎉🥳🥳💐

[@karanparashar675]

Very informative video ! thanks for your valuable insight on this topic.

[@sohamsengupta69]

Sir you are the best. Teaching us the best advance things

[@twinklemittal9740]

Mind blowing ninja technique!!! Thanxxx a lott!! 😀

[@Innozant]

Hahahaha.. Thanks Twinkle for your Lovely Appreciation..Happy Learning.Thabks for being part of Innozant family ❤️🙏👍

[@RGVVLOGS-q3z]

Bhot kamaal ho sir aap salute hai aapko 🙏

[@Innozant]

Thanks

[@prashantsolanki9131]

Bahut hi achhe videos banate ho sir🙏🙏🙏

[@Innozant]

Thanks Prashant Ji Happy Learning

[@saketmishra1470]

Sir love you yaar , aapke bolne ka style I really love it

[@mukeshbiswas6307]

Sir please keep making such videos, your way of teaching is the best with deep understanding. Thanks for maki g lot of Conceptual videos

[@Innozant]

Thanks Mukesh Ji.Really means a lot to me

[@atulshukal4072]

बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब

[@Innozant]

Thanks Atul ji...Gn

[@Kingx7565]

You are King of Excel the way you teach it's amazing lot's of love from Pakistan

[@Innozant]

Thanks Hasnain..Happy learning dear❤️❤️🙏🙏

[@aishwaryaambasta7013]

This function still give me goosebumps but after watching this video easily to understand...

[@Innozant]

Hope you may understand the concept easily and implement it.

[@pradeepnegi7523]

Nice sir, aap ke formulae jabardast hote hain sir

[@Innozant]

Thanks Negi sahab...Happy learning

[@zaibunnisa2290]

Sir u r really a good teacher. Every day I am learning new thing from your videos. Thank you so much sir.

[@Innozant]

Thanks dear ..Happy Learning

[@Knu_804]

हम जैसे नये छात्रों के कमेंट पर आपकी टीम रिप्लाई करती है हमें बहुत अच्छा लगता है ।

[@Innozant]

Thanks Vinod ji.. Happy learning ❤️

[@LalitKumar-pl5pn]

this channel diserves million of subscribers.

[@Innozant]

Really means a lot to be

[@pushkarsinghbishtuk437]

Sir aapke samjhane ka tarika bahut hi behatarin hai.

[@Innozant]

Thanks Pushkar

[@sonamn3459]

Acha explain krte h sir ap..

[@pramodbhatt6906]

Lovely Sir the way of your teaching i never seen before

[@Innozant]

Thanks Pramod Ji❤️❤️❤️👍👍

[@exceltallyguru6960]

I am also an excel trainer...I must say your videos contents are awesome..👍👍👍

[@Innozant]

Thanks dear, ❤️🙏❤️, Really means a lot to me

[@ravikagrwa]

sir your vedeo very useful for everyone....

[@TRMNPS]

Excellent tr. Always respond to the messages.

[@Innozant]

Thanks Bindu, Have a wonderful career ahead❤️

[@rashmi2848]

Tq sir . So valuable class for me

[@ishwarsingh881]

Really you are God of excel.

[@Innozant]

Thanks dear..happy learning ❤️

[@sandeepjoshi4646]

thankyou sir for every thing your are the best. guruji ....

[@Innozant]

Thanks Joshi Ji

[@Prince-f3n2e]

Very good concept sir in excel

[@JitendraKumar-gp4do]

Ati sunder sir ❤

[@nanjundeshwara-593]

super .. very very super thank you

[@ManishVerma-gg8xl]

सर बहुत ही बेहतरीन और नायाब तरीका एक से ज्यादा conditions के साथ sum करने का मजा आ गया क्युकी sumifs formula मुझे थोड़ा सा परेशान करता है पर इस प्रकार से भी कर सकते है आज आपका tutorial देखा तब मालुम चला धन्यवाद सर आपका और एक बात फ़िर से कहूंगा आपके समझाने का style बहुत शानदार है 👍👍🙏🙏🙏 एक विनती है आपसे इस प्रकार के वीडियो की यदि practise file यदि आप उपल्ब्ध करवा दो तो बड़ी मेहरबानी होगी आपकी 🙏🙏

[@Innozant]

Verma ji...alreday video description me direct link diya gya hai master assignment file download krne ke liye.. download it and start your practice

[@ManishVerma-gg8xl]

@@Innozant 🙏🙏🙏

[@balamira297]

Sir I tried this using sumproduct method with double negative ..it's working

[@Innozant]

Good 👍👍❤️Have a great day

[@someonefrom2002]

Sir aapko subscribe ke liye bolne ki zaroorat hi nhi hai 😆😆😆 No one can resist himself from subscribing you, after watching your videos even one😆😆😆❤️❤️❤️

[@Innozant]

Thanks for your love and support ❤️❤️❤️

[@hybridtheory88]

Excellent video, explaining the concepts! I was stuck in writing a formula (had the logic in mind but couldn't implement) and this video helped me with the syntax. Thanks! Liked. I've also found that the formula you've shown in this problem works without Ctrl+Shift+Enter. Please check.

[@Innozant]

Thanks Jha ji .We welcome you to experience the taste of success with Innozant-Seed of Success ❤️

[@kamleshsingh8142]

Sir, thanks from bottom of my heart, now I am fan of you, you teach in depth and focused more and more on concept, and while teaching ur smiling face make more confidence within us and also attract to watch more and more videos.

[@Innozant]

Thanks Kamlesh ji for such a valuable feedback.. Really means a lot to me.

[@pandharinathjoshi6565]

Wonderful formula, hats if ur thinking.. its usefull

[@Innozant]

Thanks Joshi Ji🙏😊❤️

[@madhavirathore4926]

Sir your way of teaching is very nice. Pls make a vedio on countif by useing array.

[@surendrajaiswal1857]

it was very complicated but you Solved sir thank you so ,much sir esi method per we can get out dynamic multiple condition filter by array formulas. i tried , answer came right .. .....😊😊😊😊👌👌👌👍👍👍👍💕💕💕💕

[@Innozant]

That's good..Ap khud alag kuch krne ki koshish krte h ye achi baat h.. Happy learning

[@Jitenderkumar-yp1rn]

Excellent example sir.....

[@Innozant]

Thanks Jeetu,Have a great day.

[@rajender811]

You continue with great work sir! I m surprised how such a great teacher getting lesser likes

[@Innozant]

Thanks dear.Keep Learning

[@akak3585]

Thanks for videos sirG

[@abhichauhan10]

Thanks a lot for teaching us..

[@Innozant]

Thanks Deepak

[@PrityDas-kn1ez]

Sir wonderful idea .

[@harivanshgautam3424]

Sir you give very sharp information about Array.🙏

[@Innozant]

Thanks Harivansh for your valuable feedback.It really gives me reason to make some good content for all of you.

[@somveergahlot362]

Sir aapke bolne ka itna asar hota hai k har vedio dekhne k baad subscribe button jroor press krta hu.

[@Innozant]

Hahahaha..Are Somveer sahav phir to unsubscribe ho gya hoga😀aisa na kro g..

[@somveergahlot362]

@@Innozant no sir bcoz second time maine Ctrl+Shift+enter kiya tha 😎

[@somveergahlot362]

I am facing ba challange in Attendance calculating sheet. How may I connect you on anydesk to explain my query Plz 🙏

[@Innozant]

@innozantofficial telegram id

[@punitsarkar4762]

You are doing a great job..thanks..

[@Innozant]

Thanks Puneet,Hope you like our video,If you want to learn from scratch , Recommend you to start watching my video from basic Excel playlist step by step.All videos are categorised and in sequence

[@punitsarkar4762]

@@Innozant Waiting for more Array function related videos from your end..

[@dhakafady774]

love you sir, thanks a lot

[@gauravbhatia7987]

Thnq sir sum array its different u to good sir am trying learning and practical apply in excel my pc thinq so much

[@Innozant]

Very good Gaurav...yes I seen ..aap bht mehnat Kar re ho..wo dikhne laga hai..bht jald test Hoga..b ready for.

[@Thedeepanshu95]

@@Innozant sir please help to get the job. you said assessment hoga agar clear ho gya to aap refer kar denge job ke liye...

[@padmakarbadge8419]

Subscribed. Amazing

[@dirghangiamit9997]

Just Awsome, I become your FAN truly.

[@Innozant]

Thanks Amit 🙏❤️God bless you dear.

[@AbdulHamid-no8lh]

Very good trainer

[@Innozant]

Thanks dear❤️❤️

[@golubro9517]

Great sir❤️

[@RohitKumar-uy7cx]

Awesome teaching Sir ji

[@Innozant]

Thanks Rohit Ji❤️

[@RohitKumar-uy7cx]

@@Innozant Sir ji time ki calculation ka bhi gyan dijiye from Basic to Advance kyoki mujhe apne office me wages calculate krni hoti hai aur excel me sheet bhi bnai hai easily kam ho jata hai par ab apne kam me smart bnna hai aur uske liye aapki help chahiye bas, agar aap chahe to bahut kuch seekh jayenge aapka 1% bhi aa jaye to bahut hai

[@Innozant]

Jarur guide krenge dear aapko.dn to worry

[@RohitKumar-uy7cx]

@@Innozant thank you sir ji

[@devenderkumar1220]

Sir thanks for this❤️

[@anayetsobuj397]

You are such a great teacher whose teaching style is really unique & analytical.i would like to thank those teachers who teach the students with entertainment.You are one of them.My complement is for you,You can understand the Students' pulse, That's why you make the Students understand easily.Supported from Bangladesh❤️

[@Innozant]

Thanks Anayet,Really means a lot to me.God bless you..Happy learning dear.

[@obaid5267]

EXCELLENT TEACHING METHOD

[@Innozant]

Thanks Rehman sahab

[@meditationmusic6482]

So nice 🤩 sir ji 😄

[@Innozant]

Thanks Sanoj ji

[@secretkingstatus9343]

Sir aap bahut achha padate ho esa koi nahi padata h

[@Innozant]

Thanks dear

[@shrikantbadge3978]

Amazing useful thank you sir

[@bhoopendraraghav9781]

Seriously very Nice

[@Innozant]

Thanks Bhoopendra Ji,hv a great day

[@rhashmi1]

Excellent!

[@MISAmber]

sir u r great

[@sushilshukla7296]

Fantastic🤘😝🤘 sir

[@Innozant]

Thanks Sushil ji❤️🙏Happy Diwali

[@ankurghosh7734]

SIR YOUR TEACHING STYLE GOOD I LIKE

[@Innozant]

Thanks Ankur

[@NaveenKumar-qo3ug]

Excellent Sir

[@Innozant]

GM.Thanks Naveen Ji👍❤️

[@sumanbhandari558]

🙏🙏🙏🙏🙏 sir bahut kuch sikha hu video dekh kar.... 🙏🙏🙏🙏

[@manishdhimmar2987]

Sir, please explain that suppose I type rendemly number in one cell and press ok . it takes rows only as many as I type number in selected cell.

[@ManojGupta-nl8fj]

Super👌👌👌

[@saritasahanisahani7837]

Very useful video

[@Innozant]

Thanks dear

[@Altaf_Alam]

Good morning sir ❤️🙏

[@anooparora2515]

Thanks Sir!

[@ShashiKumar-te1tu]

Great sir

[@mdmaruph5704]

Thank you so much Sir

[@Innozant]

Thanks dear...

[@Aghast88]

By this video, I just win an argument from my friends. Thanks Guruji.

[@Innozant]

Wow.. wonderful. Keep learning. ❤️🙏

[@aakashverma3590]

Mja aaya sir 🙏🙏🙏🙏🙏🙏👍👍👍👍

[@Innozant]

Thanks ❤️

[@murlisaini2707]

Excellent

[@kinghundred]

very good sir

[@ManjeetSingh-th4fu]

Nice 👍

[@Manojyadavdipl]

Mast jabarjast

[@pawankumar-kx1lx]

Nice❤

[@depaksati6068]

Sir aapke ye vedio se mein kaafi seekha hu...ek query hai meri...aap sumif column wise having same column name for two three column karke batayein..formula sumproduct ke alawa sir

[@Innozant]

Thanks Deepak..Ok Noted

[@naveedalidewani5282]

Sir i want to convert data from columns to Listview ... Plz suggest !!!

[@study4734]

Thanks Sir

[@padmakarbadge8419]

Thank you

[@ManishVerma-gg8xl]

इतनी अच्छी वीडियो को 1 बन्दे ने dislike किया है पता नही क्यु 😔😔

[@Innozant]

❤️❤️❤️🙏🙏

[@ishwarsingh881]

Great!

[@Innozant]

Thanks dear ..happy learning

[@horrorlovestories]

Sir 6:33 mein year ko poora freeze kyu kiya gaya hai- agar hum sirf column freeze karein toh kya yeh humein same output dega ya nahin?

[@CR_7717]

Great sir great Yor are best excel teacher main chataho ke mujhe aap se he coaching lene chiya

[@Innozant]

Thanks for your appreciation dear..Seekhte rhiye aap humesha sikahyenge aapko

[@ExcelForBeginners.]

Sir, do u have power bi videos as well

[@Innozant]

After Completion of Excel Will start Power series.

[@sitaldas6865]

Gazab sirji

[@Innozant]

Thanks Sital❤️

[@143s.p_gaming7]

Nice video sir

[@Innozant]

Thanks Shankar Lal Ji,Start learning from basic Excel playlis step by step.

[@suyashkumardewangan77]

Awesome

[@phantommemes4616]

Sir . Please teach data cleaning of bank statement sorting and anasis

[@majahidlaskar1781]

Sir you have shown us the way to calculate sum with array technique without using SUMIFS function...I tried the same approach to calculate average and median also...but it was showing proper result..plz guide

[@Innozant]

Didn't get your query .kindly explain in detail

[@majahidlaskar1781]

Sir i tried to find out average and median sales of that data set which you have explained... But i didn't find the right answer... What I did... I have put average in place of sum... But couldn't find the right answer

[@mayurshinde6958]

Sir, excel main formulas set krte samay enchizo ka upyog kaise kiya jata hey jaise ke - / , " ) - inka definition kaisa hey jaise kisko kitne bas use krna hey & kaise lena hey etc.

[@Innozant]

, is argument seprator, " use to pass text string

[@arpannandy961]

I want to learn VBA and macro from you sir.I need to learn property to make MIS report very fast.

[@Innozant]

Ok .Sure..Will start video series soon as well as New Live Classroom training for VBA are running in Innozant on regular basis

[@sadashivkage3133]

TQ...sir