Sir ji bohot hee badhiya or knowledgeable video. If, sumif or sumproduct Ka achha example Diya Aapne date ke value Ka sum Karne ke liye. Waiting for your new video for how to use offset function in this case. Very good video 🙏
Sir apne bataya tha ki agar double negative nahi lagaye to multiply ka sign use karna h lakin maine dobule negative laga kar use kiye to output different aa rha h or multiply laga kar different output . Esa kyu pls batao
Sir, aap ne vlookup and hlookup me aapne sum kiya tha house of aarry {1,2,3} ka use kar ke, muje ye bata do agar Jayda cell row aur colunm jodna ho to kya karu.
Thanks Sir,Hope you like the videos and learn from there.Recommend you to learn step by step.Videos are uploading in sequence playlistwise.Thanks for watching.Keep Supporrting.🙏
@@Innozant Sure. I am very passionate to learn more advanced Excel/Google sheet formulas. If a person knows Excel/Google sheets, he can do wonders in this world. It is an engine/igniter to do more. Thank you very much. You are doing a great /fantastic job indeed.
Sir jo apne range liya hai.. Usko hum dynamic bana sakte hai.. Jisse hum niche date or value badhate jaye automatically sum hota chala jaye.. To konsa formula lagega.. Buss itna bata dijiye formula name
Ek doubt hai ki sumifs lagate samay greater than equal to ko double quotes me rakhte ho jabki sumproduct chalate samay greater than equal to ko without double quotes chalate ho .
may I know use of sumifs with condition. suppose in between an additional column of sales person in above table. How to know one's sales amount between dates ranges?
सर इसमे थोडा ट्रिक है.. अगर starting date is grater than end date so we cant calculate but in sumproduct mujhe iferror condition lagani hai ki starting date badi hoto dikhega select proper starting date.. ohter wise some product run hoga so yeh applied kar sakte hai kya hai toh mujhe toda syntax guide kijiye miane applied kiya hai =IFERROR(value mai sumproduct condition , if error toh select proper starting date") but run nahi ho raha hai...
Dear Sir, I have a big sheet like below. there is repeated material no ( SAP NO.) that has been issued against one reservation No. Kindly assist me to get the unique material no of each reservation no. and their total qty. by using a formula (like yellow highlighted ) BR,
Kaunse date ko dynamically change krna chahte hain.phir se ek Baar query explain krna Sonal ki date ke Saath kya manipulation chahte Hain..date dynamically update krne ki liye to dataset ko table me convert Kar sakte h
sir i am accountant in construction field. i have to maintain daily work quantity in excel sheet and for this i applied sumifs formula for sum between dates it works nicely but when i add new dates in my excel table it shows error. sumifs formula doesn't update range automatically so please give some solution for this problem
Aap Innozant ke website visit karen contact details available hai ya kisi bhi latest video ke intro me contact number available hai call karke love class ka detail le sakte hain dear
Bas isi trah sikhate rahe sir..ise hamra kaam aasan jayega..
Sir aap bilkul sahi kahetey hai sumproduct is really usefull and smooth thanks again new concept of sumif and sumproduct.Good night Sir
Good Night...kal phirse ready rahiye.. Sumproduct ke Question ke liye
@@Innozant OK sir I am ready
Apne bahut achche se explain kiya , thank you sir
Thanks dear
Sir ji bohot hee badhiya or knowledgeable video. If, sumif or sumproduct Ka achha example Diya Aapne date ke value Ka sum Karne ke liye. Waiting for your new video for how to use offset function in this case. Very good video 🙏
Haan Jab offset padh lenge..again ye Question krenge offset se
@@Innozant okay Sir thanks 🙏
Sir apne bataya tha ki agar double negative nahi lagaye to multiply ka sign use karna h lakin maine dobule negative laga kar use kiye to output different aa rha h or multiply laga kar different output . Esa kyu pls batao
Sir, aap ne vlookup and hlookup me aapne sum kiya tha house of aarry {1,2,3} ka use kar ke, muje ye bata do agar Jayda cell row aur colunm jodna ho to kya karu.
Excellent. Logical, most essentially for the data analyst. Thank you very much.
Thanks Sir,Hope you like the videos and learn from there.Recommend you to learn step by step.Videos are uploading in sequence playlistwise.Thanks for watching.Keep Supporrting.🙏
@@Innozant Sure. I am very passionate to learn more advanced Excel/Google sheet formulas. If a person knows Excel/Google sheets, he can do wonders in this world. It is an engine/igniter to do more. Thank you very much. You are doing a great /fantastic job indeed.
Amazing video ever!! I am learning a lot consistently by watching your video.
Thank you very much, Sir!
Thanks Aamir sahab👍❤️
Sir agar mera arrays columns m ho toh hmm sumproduct lagabsakte h
Sir jo apne range liya hai.. Usko hum dynamic bana sakte hai.. Jisse hum niche date or value badhate jaye automatically sum hota chala jaye.. To konsa formula lagega.. Buss itna bata dijiye formula name
Amaging, you are big boss sir
Thanks Ajay ji.
Sir very nice but you didn't show the formula how from to means from monday to .....comes
Sir plz explain how to extract data between multiple sheets and between dates. And multiple criteria.
Ek doubt hai ki sumifs lagate samay greater than equal to ko double quotes me rakhte ho jabki sumproduct chalate samay greater than equal to ko without double quotes chalate ho .
Thank u
may I know use of sumifs with condition. suppose in between an additional column of sales person in above table. How to know one's sales amount between dates ranges?
Kindly check other video of sumifs for your query .
sir apa to mahan ho Excel ka
Sir in which video i can understand the concept of entering "=>".
Sir tableau b sikhaye
Nice video sir but access or Power bi per bhi video bnao
Tine ke saath har ek series complete titorial step by steo milega har topic par
Excellent sir
Thanks Koushik ❤️
Sir, I want to ask you one question. What if we pass reference of F column instead of date value cell? It will & should give the same result.
Superb sir Ji🙏🙌
❤️🙏
Sir is video me aapne bola hai ise hum offset se bhi solve karenge please us video ka link send kar dijiye
Sir kisi perticular date ke pahle ya baad ka total amount nikalna he to sumifs se kese solve karenge
Good sir
Thanks Gaurav ji🙏❤️ Thanks for Supporrting
Marvellous 👌👌
Ap boht easy sikhaty to mjhy sikha dijye
Very nice exllent 👍👌👌👌
Sir..how can we addition like
4yrs,5month,10days. +
7yrs,8month,30days
Please assist me
Great Sir 👍
Thanks dear
Hats of you sir g
Thanks Bhoopi..gn
@@Innozant wlcm sir good night sir.
Thnx u sir 😊🤗🤗🤗
Keep learning..in sequence..step by step from playlist .
@@Innozant kk sir 🤗
Dear, similarly can we get max value bw two dates
yes we can
सर इसमे थोडा ट्रिक है.. अगर starting date is grater than end date so we cant calculate but in sumproduct mujhe iferror condition lagani hai ki starting date badi hoto dikhega select proper starting date.. ohter wise some product run hoga so yeh applied kar sakte hai kya hai toh mujhe toda syntax guide kijiye miane applied kiya hai =IFERROR(value mai sumproduct condition , if error toh select proper starting date") but run nahi ho raha hai...
Kya laga re h formula Sumproduct ka..wana see that
Dear Sir,
I have a big sheet like below.
there is repeated material no ( SAP NO.) that has been issued against one reservation No.
Kindly assist me to get the unique material no of each reservation no. and their total qty. by using a formula (like yellow highlighted )
BR,
Kindly share your excel.sheet with query explanation @innozantofficial telegram id
Jhakkkaaasssss...
sir isme >= kyun use kiya gaya hai nhi samajh aaya hai...kya aap reply kr sakte hai?
Sir ek query hai....last date to apne fix krdiye ho..mai chahta hu jab new entry ho to automatically last entry ko last le....is it possible?
Convert range into table then apply formula
@@Innozant yes
@@Innozant dashboard aur macro ka video kb ayega sir....still waiting
Sir batay date dynamic kaise change hoi
Kaunse date ko dynamically change krna chahte hain.phir se ek Baar query explain krna Sonal ki date ke Saath kya manipulation chahte Hain..date dynamically update krne ki liye to dataset ko table me convert Kar sakte h
👌👌👌👌👌👌👌👌👌👌👌
🙏❤️👍
sir i am accountant in construction field. i have to maintain daily work quantity in excel sheet and for this i applied sumifs formula for sum between dates it works nicely but when i add new dates in my excel table it shows error. sumifs formula doesn't update range automatically so please give some solution for this problem
Convert range into table
@@Innozant sir it is already converted in table still it's error . I have to manually drag formula range
Sir I have tried but could not do it. Can you tell the formula to highlight the selected date period with conditional formatting
What you want to do Shrikant Ji with Date ..I mean share your data format or explain
@@Innozant in this same video Sir. I want to highlight(date column) start date to end date.
Use datevalue greater 1st cell and less than last cell inside AND
@@Innozant not working , please share me your email id
innozantcampus@gmail.com
Sir ap ye full date lekar kese aye sum of sales ke neche wale cell me
Evaluate kiya hoga formula ko using F9
Please share subtotal short cut key
Alt+A+B
Like Alt+=
sir, jab mai dono data dalta hu tabhi value reflect ho rha hia, jab cell blank rahne deta hu to value nahi aa rha hia
kuch mistake to nhi kar re h
@@Innozant nahi baba, jaise jaise bataya apne waise waise kiya hu, jab date dono date daal rha hu tabhi value aa rha hai
⭐⭐⭐⭐⭐
Mere interview me isi lr question tha main nhi solve kar paya🥲
मान लो कि मेरे पास यही डाटा है और उस डाटा के अंदर मेरे पास टाइम है.. तो मैं टाइम and Date vice दोनों को कैसे निकाल सकूंगा?.
sorry to bother u again, i did"t find this Practice sheet under that name.
Assignment Master -Excel Array & Sumproduct-sumbetweendates.xlsx
=SUMPRODUCT($B$3:$B$93>=$G$3)*($B$3:$B$93
Kaunsa Questions kar re hain ?
up akber =SUMPRODUCT((...
ei kark dekhiy...
solve hojaiga..
Sir ye words dikhai nhi de rahe h ink week h please dusri bar vedio bana do
Excel file hoga usse kar lijiye practice
How to make a data scientist
Start your learning joury from basics
=SUMIFS($C$3:$C$93,$B$3:$B$93,">="&F3,B3:$B$93,"
Sumproduct se kyu nhi aayega..try again
Sir pls apna number share kijiye pls
Aap Innozant ke website visit karen contact details available hai ya kisi bhi latest video ke intro me contact number available hai call karke love class ka detail le sakte hain dear