Excel SUM Formula Series | 4 एक्सेल फार्मूला 1 वीडियो में 

count basic salary only odd no. employee id..? how to use formula

Innocent man

Awasome teaching skills. Wonderful 👌👌👌

Please share that how to. Compare two excell sheets with same names

Sar app Sam +Karna bat ya ho subtrect - ke liya nahi bata ta ho

sir sumif ka formula kaam nahi kr raha kya karon plzz reply me.mene bohat koshish ki hai

6688 9 22 3344 6 55 11 6 0033 Is there any condition so I can find above numbers are Special numbers due to 1st & 2nd digit are same, 3rd & 4th Digit are same . On Third number 4th & 5th digit are same and 6th & 7th digit are same. Pls tell me any formula or logic in which I can find these type of Special Numbers from Data which have 1000 of numbers.

>50 ka to mtlb hua 50 se jada lekin aapne kaha 50 k barabar?

Nice Video Sir...

Aapka andaaz bht pasand aya sirjii

Thank you sir 🙏🙏🙏🙏

Which formula where we can use them can u tell me ? I'm telling about all formulas.. Koun sa formula kab use karna hai.. Use kha par apply karna hai.. Ise par ek video bante app tho mera doubt clear hojata sir ??? Please reply me

Nice sir

sb kuch shi a raha hai sirf tom ka hi 0 a raha hai sir kyo

Yeh details nikalna ho to kaise nikalenge sir Nawab bhai ko site number 25 par aur side number 30 par kitna cash diya hai aur kitna bank se 🙏 please batayein

Wawooo sir you are great

सर् , दाढ़ी क्यो बढ़ा ली ??

Nice video sir

Superb 🤩

Super

Thanks sir

Sir mujhy apsay bank m Jo bhi work hota h use releted video bano kuki mujhy bank ki job karni h isliy pls hepl me

Thank you

Thank you sir providing for best teaching skills 🙏🙏

sir mere me tom ke 0 a rhe hai

Very good sir .kiya ap mujhe bata sakty wo kon se important formulas hai jo job ke liye zyada use hoty hai pls sir

Hi sir, main ek sheet banana chahta hu, for production calculate Sunday ko skip karke.

sir plz upload excel formula most used in office like data validation n sent a link of practice files like this videos .it will be very helpful

Sir apki sabhi video bahut jaldi samjh aati h or ap ka y coaching kaha h .mai to Delhi say hu near metro gokalpuri h

Sir mujhe formula error mei msg type karte hai wo video ka link send kar do

sirjee....... i want to know that why the "*" sign put in name start with sumif formula???

sir please explain how to do sum of evry alternate cell

Sir total ke column me automatically sum change hona chahiye cell ka digit change karne par .

Awesome video!! You teach in a very interesting way Sir!

Sir ji main AAP se sumifs sare video sikhana chahun ga jaise AAP ne kaha hai ki he 200 se Jada hai

Sir your sound tempo is little low.. But nice video.

Thakns you sir your videos is amazing plz Carry on..

Superb simple and detailed learning 👌

Sir aapke videos ne bht sikha diya and saath mai aacha sense of humor ! great thanks for all this :D

hi sir what is the meaning of * in criteria in sumifs for what this sign * is used??

I like your voice and smile

Very good trik 👍

You are simply Awesome.

Sir kaya merg function ki koi short key hai

Sir ji sumif aur sumifs dono ek saath kaise use kar sakte hai

sir ap GST Bill kaise banate hai usake bare me deeply bataye

Ye lodu apna guru h

Sir kisi liquid products ko litar me convert karne ka formula batay

Lcm

Excellent job

Thanks sir

Like your stuff bro Keep it up

Nice sir

Thanks Sir

awesome

You are doing great job...

Following although I wish it was in English!

Super 👍 very helpful video sir

The way you teaching it is interesting to listen the video,it was extremely valuable stuff.

I am facing a strange problem. In Sum & Large (Nested) formula, Here is the process I did- I typed some figures (5,7,3,9,0,0) in cell row (C5 to C11). Now I used "IF" formula in cell row C15 to C20 instructing that if Cells C5 to C11 Contains a number that is more than 1 then put ".5" in cells C15 to C20 else display 0. It worked well & I got desired number (.5) in desired row (C15 to C20). Now problem began In Cell C21, I put SUM +LARGE formula together instructing to display "SUM of top 4 numbers from selected cell rows C15 to C20". They all carry same number / figure (.5). But it shows a "Number_Error"? I thought that formula (SUM+LARGE) is not recognizing digits contained in C15 to C20 (.5) as number because there were not typed there but appeared through "If" formula. To confirm that I used only "SUM" formula by selecting cells (C15 to C20). I thought when formula (SUM + Large) is not recognizing ".5" contained in row (C15 to C20) as number then "Sum Function" will also not recognize it as a number & will not give me total of it (C15 to C20). But I was stunned when SUM formula gave me the correct result! That means- digits of (.5) are well recognized correctly by formula but nested formula (SUME + LARGE) is showing "Number_Error". I have given up so seeking you for help. Another probability is- nested formula (SUM + LARGE) doesn't work for a row? but only for column or whole array? I don't know. Being expert in field only you can deal with this. Please help & Oblige Thanks Dr. Atul Tiwari (MD)

SIR, If column A is present stock, column B is newly added stock and column C is present updated stock. then can you tell me what should be an excel formula that always shows the exact quantity of stock in column C. Even if I add multiple time new stock in column B it will also add the previous value in column B and shows the exact quantity in column C. plz Also, tell me in which column I have to apply the formula

superbbb sir