Use SUMIF Function - VBA Hindi -Series 12 - Video 693

[@RSDubey-oe1ig]

wah kya bat hai bhai .. mujhe bahut achha lga video bnane ka way ... baki ke jo or bhai log video bnate hai vo sale jitna bataynege nhi usase jyada bakwas kar ke time vast kar dete hai ... jo logo ko sikhna hota hai vo log bakwas nhi sunnte hai point ki bate sunnte hai .. esi wajah mai mostly video forenners ki dekhta hu hmare indian bhai log to... ek Vlookup btane ke liye 10-15 min le lete hai or logo ke pas etna time nhi hai.. short time me chijo ko explain krne se ... bachhe jyada learn karne ki kosis krte hai ...Thanks for making wonderful video.. i appreciate you 🤗🤗👍🏻😇😇

[@mohammadraiesh4648]

Nice video. Bahut maza aa raha hai VBA Sikhne me. Ajay Sir Apka tahe Dil se Sukriya. Aap Dil khol ke sikha rahe hai. Video dekhte Samay lagta hai Ru ba ru class chal raha hai.

[@adirohila]

Yeh h real VBA tutor wali baat jo sawal tha uska jawab pahale hi de diya.Ye hi wajah aapke har video ka besabri se intezar rhta h ki aaj kuchh naya dekhne ko milega aur jo milta h wo bhi shandaar aur jandaar hota h. Thanks for your all fantastic series.

[@AjayKumarparmar]

Aditya ye compliment zabardast dia. Bahut bahut shukria... Aapke Comment hamesha aate hai. Thank you. Apne channel ko share karte rahe roz.. Bahut duur tak Jana hai...

[@ajitpatel955]

बेहतरीन तरीके से सिखाते हो आप कोई भी व्यक्ति थोड़ी मेहनत से आराम से सीख सकता है धन्यवाद सर

[@AjayKumarparmar]

Shukria aapka

[@radhabid9100]

Thank you sir

[@pawantrivedi4966]

no words for your way of teaching. Simply can be understood and learnt

[@AjayKumarparmar]

Glad to hear that

[@sangramjsw]

Best teaching skill Sir.

[@ArshadKhan-ro6dj]

Great video for VBA learner with excellent communication skills.

[@AjayKumarparmar]

Long way to go.. Will start advance excel and access vba too... Please bring students here. This is your channel too

[@rakeshkumarmadella7955]

Simply superb hai ji.. really really I enjoy ur channel very much sir

[@rakeshsaroj4505]

Sir, Nice video sir hindi valo ke liye kafi halp full hai Thank for your video

[@mdbelal1316]

Amazing Tutorial sir. I am searching for this type of tutorial for a long time, I saw many videos but not found as it is, I m so glade and obliged you enough.

[@ashusaxena1084]

Mene sari Video dekhi bahut badiya

[@AnalyticsInDetails]

You cover lots of other things in one video much appreciated. Excitement and confidence in your voice make me energetic.

[@AjayKumarparmar]

India has got talent. Rise and shine. Cheers

[@rahulfageria6564]

Super!!! Your way of teaching covers previous series as well as errors that helps to connect the old series and clear all the doubts. and voice ke liye to yhi kahuanga "Dam hai Boss" - Full of Energy :) Adding one more talent in this lockdown period and hope I will be a good programmer very soon :)

[@Yummyfoodie9917]

Very helpful videos thank you so much ajay sir 😊

[@asifraini5190]

Ultimate video. very very helpful..great teaching skill love it..Keep it up Sir..........

[@ssafwan228]

What a wonderful example and good video sir

[@AjayKumarparmar]

Shukria bhai jaan

[@deepakgupta3192]

Thanks learning a lot from ur series , last video u said we only have covered 10% I thought we are about to finish the course .

[@zeeshanzeenu]

INCREDIBLE Sir.........

[@AjayYadav-mj7ge]

very , very usefull video sir

[@ashusaxena1084]

Very very thankyou Ajay sir

[@mohammadtarique9640]

Really appreciable

[@geetamsingh8697]

Very helpful sir , thank you so much sir

[@MrMallesh1]

Lovely Video Sir, Thank u so much for this video !!!!

[@girishsawant8263]

Superb Sir ! Thank You So Much !!

[@Jaspal00Bisht]

Fantastic sir.

[@shoryaarora1464]

New learning sir ji thanks ji

[@rakeshkumarjha6965]

great sir very helpful

[@rajanrai101]

Very useful ❤️

[@ahmedreza3031]

GREAT SIR..LOVE U

[@bapumote8921]

Awesome !!!!!

[@maheshswami2064]

Lajwab sir ji

[@anandgp07]

THANK YOU GURU JI

[@mindgame8232]

sir aap to great hai. i love you sir.

[@carloszurielchavez1198]

You are my heroe!!!!

[@muzzammilsiddiqui1146]

Great Sir

[@hemdasmahant9407]

Good better bast

[@neetshil1434]

Very nice video

[@NitaFunnyVideo]

Thanks

[@shashikumarbugide4816]

Sir, Could I put target cell in changing event rather than total worksheet.

[@maheshswami2064]

Mja aa gya sir

[@Rwt.aje1]

Awesome :)

[@AmolPatil-lr4ow]

With same data i want to extract details like name in row, and year in coloumn then how we can get sum

[@prakashchandra5239]

Hi Ajay as I told you earlier you just rock application.enableevents=false/true was really so good. But there is a single query what we should do if I just was to limit this event to a specific range. I.e in this video you have used e7 but I want to limit this event that it should run only if my e7 cell change. Hope you understood.👌👌👌👌

[@AjayKumarparmar]

Use intersection function

[@manishjain9320]

Nice video sir. But series 10 mein last function Strrev ka video nahi bana hai .Pls check

[@rajm5349]

sir how to make this dynamic, suppose if there is any data added in the row then how to overcome the issue.

[@AjayKumarparmar]

Use loop

[@surajbagkar9792]

u rock

[@MUKESHPGO]

सर् हमे इस डेटा से किसी एक पर्टिकुलर वेक्ति का नाम और उसी व्यएक्ति का मार्क्स निकलना हो अलग अलग तो कैसे होगा? प्लीज़ बताये

[@azhadshamim3122]

Sir It's great video But my question is " I have 50 items which always receive in my medical store , but I don't want change name once I put serial by serial and want to get sumif results through VBA automatically without selecting the item Plz kindly a video reference Thank you

[@AjayKumarparmar]

Use VBA event or vlookup vba

[@naveednak5113]

Hello sir cstr vba K bare me kuch batae oos ko kis maqsad ke lea estemal kya jaata he

[@AjayKumarparmar]

To convert number into string

[@ankitgarg2530]

what is the use set ?

[@AjayKumarparmar]

to declare objects you use it

[@paramjeet975singh3]

sir ye to xcel se bhi ho jata hai fir code kyo lagaye plz batana sir jii plxxzz

[@mdjasim-qq2fc]

Sir how to return sheet into cell video full details in hindi please

[@maitraythakkar9664]

ayaysir teaches like enable events function

[@mdjasim-qq2fc]

Ardently sir

[@saadwahid5307]

SUMIF Function - VBA FILE DOWNLOAD ME RAKHEE SAJHNE KEE LIYEE

[@muzzammilsiddiqui1146]

Data Table Name | Salary1 | Salary2 -- |Name | Salary1 | Salary2 AA 100 150 AA BB 200 220 BB "How we can make the dynamic sumifs so that i can fill the both fields or incase these fields will be increase or decrease then how we will manage please help sir" Sub sumifs1() Dim i As Long, lrow As Long, lcol As Long, j As Long lrow = Range("i1000").End(xlUp).Row lcol = Range("cz3").End(xlToLeft).Column For i = 4 To lrow For j = 10 To lcol Cells(i, j) = WorksheetFunction.Sumifs(Range("D:D"), Range("C:C"), Range("i" & i)) Next j Next i End Sub

[@saadwahid5307]

data sumifs vba code

[@geetamsingh8697]

Very helpful sir , thank you so much sir

[@mansoormushtaq2875]

Great sir

[@saadwahid5307]

SUMIF Function - VBA FILE DOWNLOAD ME RAKHEE SAJHNE KEE LIYEE

[@saadwahid5307]

SUMIF Function - VBA FILE DOWNLOAD ME RAKHEE SAJHNE KEE LIYEE