*Jai HIND Friends* *Show your love 👉 like Comment & Subscribe* THANKS FOR WATCHING 😊

@Kaushikblogs

4 жыл бұрын

Sir iska koi solution h ya nhi

@Kaushikblogs

4 жыл бұрын

Agar hum GSTR-2A download karte then different date ka sum karte hain to zero aata h

@Kaushikblogs

4 жыл бұрын

Sir me aapki kii video miss nhi karta

@worldpeace2354

4 жыл бұрын

Mujhe apne office men ek saal ke baad security release karni hoti Hain. Main chahta hoon ki jaise hi date of start aur date of completion ke beech 360 din poore hon. To khud b khud message ajae ki security is due.

@worldpeace2354

4 жыл бұрын

Meri samasya pr awashya Dhyan deejiye. Abhari rahunga mera no hai 9911401251

simple but tricky, very good and useful

automatic like button press after watching your videos

important video. Thank you Dada. 👌👍❤

Very Nice Thank you

Nice videos. Thanks for this.

Thank you so much Sir

Thanks a lot for easy method teaching

This is a very good explanation of sumifs. I think that no one can explain this formula batter than Deepak, if anyone cannot understand it, then he / she should see this video repeatedly, will be understand by someone if they are little intelligent. I was searching of this kind of explainatory video, which I gotten today after a very struggle, thanks you very much Deepak Sir, God may bless you.

@DeepakEduWorld

2 жыл бұрын

🤗

Deepak Sir, बहुत important concept बताया है, thanks. ; )

@DeepakEduWorld

4 жыл бұрын

😊😊😊😊

Thank you brother, you helped me in my office work

The Great Bhai 👌👌👌👌👌👌👍👍👍👍👍

Bhaiya G "Dhanyawad"

Thanku sir wonderful

Wonderful trick...

Good Friend 😅🤠 It's helpful

Such a another video 📹.... Thank you so much for this interesting post

@DeepakEduWorld

4 жыл бұрын

😊😊😊♥️♥️♥️

Thank You Sir🙏

Sir most useful trip. Please start Excel VBA SERIES

Thanks bro. actually I forgot this but you remind me again..i try and applied on 3 things like LIke first I choose Qty, Date, and then product which makes more complex criteria,, but thanks bro for teaching me again..

Very Nice Sir ji

Thank you very much Deepak

Hat's off to you Sir love from Pakistan ❤️

Thanks a lot 🙏 🙏 😑

sir your video is very intersting

Very useful video

tanxxx so much u r beast teacher

Thanks sir for sharing. I was searching these formulas for a long time. You have cleared my doubt. Sir one request to you is please make a video on billing statement in Ms excel.

@DeepakEduWorld

4 жыл бұрын

👍😊😊😊

Great!!🙏

Thank you so very much sir jee🙏❤💝💖💗🎉🎆

Very good concept

Thanks sir

Apki mehant tarriphe kabil hai mene to aap ko excel man liya hai

@DeepakEduWorld

4 жыл бұрын

🥰♥️

Thank you, very useful Sir Why you do not answer some of the comments

Sir excel smj agya ap JavaScript s realted video bna l

Great

Achha laga 👍👍👍👍

@DeepakEduWorld

4 жыл бұрын

😊

i continue follow your very useful videos it solved so many problem thank you very much now i have one quarry i have amc business my employee visited different area for service i unable to do in excel to find the expenses of different area for example i have 4 site say abcd i visited all the site several times i want i much i spend for visit and how much reaming from amc value thanking you

Can sumifs formula be applied in columns instead of rows.

Excellent

Please make a video = count data by name between the 2 date

Hi sirji good morning... seeking your support to create ppt ..that shows us how to find circular reference errors & correct them in excel

Good work

Good. Will you tell me how to find out the sum of the amount of a specific item between two dates.

Thank you

nice job. please share all file excel, Sir

Hello Deepak, Please make videos financial series like cash book, working capital etc. Thanks

@DeepakEduWorld

4 жыл бұрын

👍👍👍

right work

@DeepakEduWorld

4 жыл бұрын

😊

Hi deepak bhai kia ye ho sakta he k wo date bhi filter jaen

Nice video

@DeepakEduWorld

4 жыл бұрын

😊😊😊😊

Sir aap ne jo bataya sumifs me particular date me hame koi particular item jaise only hard disk total chahiye to kya formula he

Dear , 1 question, 1. I have some main time range, As example = *cell 1 = 8:15 to 10:15 *cell 2= 8:15 to 12:10 *cell 3 = 10:10 to 11:20 2. My break time is fix is 10:12 to 10:27 Now question is how i calculate in between time by ignor break time if pass in main time by same formula in every cell

👍

Very good How to hide formula bar with password. Please make a video asap.

@DeepakEduWorld

4 жыл бұрын

Good 👍🏻. I ll make a video shortly

Sir JavaScript p ek he video bna d basic he bta den

Bhai aapne Qty wali range ko select kiye bina kaise total orders nikal i don't understand, please explain me?

@DeepakEduWorld

2 жыл бұрын

Aap aek bar fir se video dekho dhyaan se 👍 aa jayega samagh me

These formulas not working other work sheet. How is it possible?

Sir ap excel customize software bnana sekhy

@DeepakEduWorld

4 жыл бұрын

kzread.info/dash/bejne/h4ytr9Ccdc63drg.html

Namste Sir ji Daily Date wise sale mai cash or borrow amount ke liye kon sa formula lagega(Sumif/Sumifs) plz help me sir ji

From beginning

Sir Mera ek query hai Agar mughe time diff.calculation ke liye date change karna hai date 03.01.2019 ko actual date format me aur main Formula =date(year(right(cell ref,4)),month(mid(cell ref,4,2)),day(left(cell ref,2))) But mughe date sahi nahi mil Rahi hai.koi aur tareeka hai single click me change karna to PL tell me Thank

Months count kaise Kare that falls between a given range of dates?

Sir y customize nai point of sale p sir software complete bnanan sekhy

I need to know how to count total number of absents of particular students within two dates. it means we have to data ranges. 1- is start and end date, 2- the daily attendance like A for Absent and P for Present. i need to count how many time student one was absent in the data range and date range. how to combine these two.

Nice

Hi bro how to use if formula in digits... If i have number 1,2,3,4,5,6,7,8,9 I need 1,3,5 1st priority and 2,6 2nd priority 4,7,8,9 3rd priority... Please reply

Sir aapka koi paid version hai kya Excell

Sir, Formula ko or badao mouse kitna qty, Keyboard kitna qty hai isa or multiple karao pls ...kyonki aksar iska use hota hai

Great dear, very good video, is it any problem if we have empty cell in date criteria , because i try this formula and result is coming in error. Pls help

@zubairkhan7461

3 жыл бұрын

No Reply??

Good video but I dont understand dates of two cells I see 01/01/2019 but I dont see 02/01/2019 ??? confused for how it got result of total order = 7

@DeepakEduWorld

4 жыл бұрын

Countifs counting dates between these date in table... Plz check there is only 7 records between these dates

Sir how To count values in two dates In an other culam like as sumif in top video

Column me tatal dates kitni mentioned. Hai wo kaise kare count

M using this in one of my data. 4-5 criteria already in this sheet. Suppose i wamt to calculate the prodution data plan vs actual on daily basis . So in date criteria start date created with datevalue formula and end date eom formula . And one date column is drop down list . So i want select last date with drop down list and start date with datevalue fun . M not getting the proper result as daily basis end date will change to add daily production data. Plz help

Sir ek date se dusri date tak ka data hum vlookup kr skte h kya dusri sheet par...?

@DeepakEduWorld

4 жыл бұрын

Yaaaa.. thoda sa wait kro.. i will publish video

@ShyamSharma-bo7nd

4 жыл бұрын

@@DeepakEduWorld ji sir thank you

Sir Excel 2019 me Power Query se Wab page ka data pull kese kare or Micro kese record kare Data pulling ka....

@DeepakEduWorld

4 жыл бұрын

I ll try to publish video on this topic as soon as possible

My answer is displayed in the below row of the same column, why?

Sir single date ka kaise kre amount

AP sy ye pochna tha KY agr Excel mein ham salry shet bnaty Hein os mein paid or unpaid employee hoty Hein or jb hm kisi unpaid employee ka data inter krein to os KY agy auto paid likha Howa aa jaein or unpaid sy wo paid mein add ho Jaye???

Agar main nay check karna ho k mouse ke ek date say dusri date tak kitni amount hai to kia formula ho ga?

Practice File Please ?

Add product wise tell me sir

Ms office 2007 me ye features hoga sir please comment kar ke batate

@DeepakEduWorld

4 жыл бұрын

Ysss

I have the question sir

suppose ham jo date range men den sirf wo data filtr ho jaey

@DeepakEduWorld

4 жыл бұрын

Use liye aap filter apply kr lo... Or subtotal lagao

Sir JavaScript p k koi link ha tu bhj d m wha s sekh leta hun

sir data Ko date wise sort kaise kre...ye aaj tak nhi PTA chla so plz btayiye

@DeepakEduWorld

4 жыл бұрын

Simple sort kr lijiye . Smallest to largest. And largest to smallest

@harvindersingh7064

4 жыл бұрын

Deepak EduWorld usse nhi hota sort JB date month and year alag alag h

Sir computer me Windows kese dalte he es par video banuo ye kafi logo ke problem he

@DeepakEduWorld

4 жыл бұрын

Okay g . I ll make video as soon as possible

Kam ka hai.

Plz help me one problem

how to same work in VBA??? HINDI ME

Can Sumifs between 2 times is its possible. Make one video bro

Countif and sumif filter me kaise lagaye

Sir agar question me ye puche ki 1/1/19 se 7/1/19 tak Ram kitana saman le gaya to ye kaise nikale

& ka sign kya kaam kr rha h ye to btaya nhi

Sumif के फार्मूला में between date aur qty ka sum निकाला अगर उसमे हमें sirf item में से mouse का चाहिए तो क्या फार्मूला होगा यानी date between qty का total और item choice like keyboard mouse etc.ki वो तारीख के बीच मे total माऊस की sale कितनी हुई

If put some value in cell (for Example :- one day worker's detail 1mason+2helper+1carpenter Second day 2mason+ 4helper How to sum candidates come in two days

5 to 10 ke beech mein 7 values hain sir, mere sath bhi yhi problem ho rho hai

Sir order count data se match ni lga plz sir explain again

& ku lagaya h "

At least read Start date & End date in right format. You read aloud these data in Indian DD-MM-YYYY. Whereas Order_Data is written in MM-DD-YYYY format. This mixture confuses many people.

@muhammadaqib7547

2 жыл бұрын

SAME CONCREN DEAR