Это видео недоступно.
Сожалеем об этом.
SUMIF formula in excel | Excel SUMIF Function
- Добавить в
- Мой плейлист
- Посмотреть позже
- Поделиться
Поделиться
HTML-код
Размер видео:
- Опубликовано: 19 авг 2024
Комментарии • 161
Следующие
Автовоспроизведение
How to use AVERAGEIF function in Excel | HindiExcel Superstar
Просмотров 20 тыс.
SUMIF Function in Excel TutorialKevin Stratvert
Просмотров 245 тыс.
MS Excel: A to Z Logical Function | Excel in HindiExcel Superstar
Просмотров 203 тыс.
The Scariest Night of my Life.SocksStudios
Просмотров 726 тыс.
HIGHLIGHTS | All Blacks v Argentina | Auckland, 2024All Blacks
Просмотров 472 тыс.
Lady Gaga, Bruno Mars - Die With A Smile (Official Music Video)LadyGagaVEVO
Просмотров 13 млн
I Build 3 Cutting Boards - 5 Min vs. 5 Hour vs. 5 DayJohn Malecki
Просмотров 345 тыс.
Match function with VLookup formula in Excel | Part 1 | HindiExcel Superstar
Просмотров 134 тыс.
SUMIFS Formula in Excel in Hindi || SUMIF and SUMIFS Excel Functions | Deepak EduWorldDeepak EduWorld
Просмотров 1 млн
Pivot Table Excel in 28 Minutes - Pivot Table Excel in HindiExcel Superstar
Просмотров 325 тыс.
Excel Sumif Function | Sumifs formula in excel in hindiInnozant
Просмотров 205 тыс.
Excel Lookup Formulas: Lookup vs VLookup vs HLookup vs MatchExcel Superstar
Просмотров 208 тыс.
Excel useful formula Series in Hindi - Part - 6Excel Tutorial
Просмотров 60 тыс.
Why You Should Use LET Function in ExcelDeepak EduWorld
Просмотров 116 тыс.
Excel VLookup Formula in 8 Minutes [VLookup in Excel]Excel Superstar
Просмотров 1,9 млн
Complete All Sum formula in excel like SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2 ETCComputer Gyan Guruji
Просмотров 886 тыс.
ЭКСПЕДИЦИЯ! | ТРАКТОР ТДТ-55 | ЧУГУННЫЕ БАТАРЕИ, ТРАКИ ПАЧКАМИ! "МАСТЕРСКИЕ ГУЛАГА" ЭТО ДАЛЬНЯЯ ЗОНАВсё из за Метало Копа
Просмотров 328 тыс.
Rusiya Prezidenti Vladimir Putin BakıdadırBBC News Azərbaycanca
Просмотров 129 тыс.
Angelo Song Tu To Riyal😆 | Brawl Stars #shorts #brawlstarsCaptain Shiraj
Просмотров 2,3 млн
Tanish holatmi?😅❤️Zakirovlar_Oilasi
Просмотров 884 тыс.
Bottle cap wood grain water transfer printing#hydrographic #craftshorts #printing #diy #shortsHYDRO DIPPING ARTIST
Просмотров 859 тыс.
АЛАУДИНОВ у Скабеевой: эти их ВСУ нас НЕ ДОГОНЯТ 😁 [Пародия]Юрий ВЕЛИКИЙ
Просмотров 971 тыс.
Ik Heb Aardbeien Gemaakt Van Kip🍓🐔😋Cool Tool SHORTS Netherlands
Просмотров 2,2 млн
ПЕРЕЖИЛ 100 ЛЕТ ЛЕДНИКОВОГО ПЕРИОДА В МАЙНКРАФТЕ!Бурёночек🛑
Просмотров 331 тыс.
Click here for Excel Basic to Pro Course: bit.ly/34GhsCM
you have a really good voice yk, you can try dubbing :)
Indeed you are a superman of excell
Agree sir, youre the number one Chartered accountant.,, thanks for being there. ALLAH bless you
Fawad Matloob how do u know he is a chartered accountant
THNKS NICE EXPLINE AND VOICE
You have a very friendly way of explaining so that even an old and dumb person like me could understand it. My compliments to you.
This has to be the bestestest way of explaining.!!!
Amazingg thankyou soooooo much!
You're the best Rishabh Sir.
इस वीडियो को देखकर मेंरी प्रोबलम सॉल्व हो गयी है। धन्यवाद
Very easy method...thank you sir...it will useful for me in my daily life
Good to See. Very Helpful😍😍
Thanks sir for your video . it truly help me.
Glad to hear that
thank you sir your teaching method is so fantastic
Behtreen explanation
Thank you so much, really appreciate the quick and understandable explanation 😁
Glad it helped!
Apki awz bht achi h
Thankyou so much sir
Very nice thanks
Ohhhh.....Very nice thank you sir ji
Sir, thanks
Thanks a lot for making this video
Well done
Thank you bhai
Yaa superbb
Ap 1 vedio bnaow advance exel interview ka bht need ha your method is very easy
sir aap ka sam jhane ka tarika bahut achha hai
EXCELLENT
Really liked your video
Awesome
Thank you
Thank u so much
Really veryyyyyyyy helpful
Honestly you are a super star teacher of excel, you explains very well simply and clearly of each part
Very very nice 😊😊
Thank you sir
Nicely example.
Thanks! 😃
i dont understand why these indian youtubers write the title in english but the guy explains in indian language
Nice way of teaching. keep it up.
Bhai aapki voice quality bhot acchi Hai
Thanks Alot sir
Excellent dear
Thank you Sir
Sir make a video about vlookup and hlookup function
Good information
Very nice video
Thanks a lot sir . I have tried for two or three times then I got and did it.
Well done
Thank you Brother❤
Thanks
thanks it was helpful.
Nice sir 👍🏻👍🏻
Keep watching
Thankyou
thanks Bhai
Thnx🙏
Welcome 😊
Excellent speaking skills, super boy
YOU GOT NEW SUBSCRIBER, KUDOS
Sir please prepare videos based on Account Reconciliation by using advance excel tools. Example : Matching cash book with bank statements. Thanks
Thanks Sir.
Most welcome
Good teaching sir
Thanks and welcome
Nice explain sir. Please explain sumifs
Thankyou bro😭😭😭
Your voice 🔥
I frickin love you dude ❤️💙
why we freeze range? please answer....
Good sir
Thanks boss
We can easily create sumif formula with the help of excel vba
Sub sumif()
Range("b9").Value = Application.WorksheetFunction.sumif(Range("a2:a8"), 1680, Range("b2:b8"))
End Sub
#excel #vba #excelvba #microsoftexcel #microsoftoffice #data #sum #sumif #vbamacro #vbacode #excelformula
Thanks 😊
Welcome 😊
Best
thnkx so much sir..
Most welcome
thanku sir
thanks , it truly help me !
🙏
upon different selection of cells, why it shows 5 instead of 4. Why 5 and not 6, 7, 8 or any error.
Please confirm me why use f4 to fix both thing
Sir, how to solve excel errors? Please upload video on solving all kind of excel errors
Nice 👍
Thanks ✌
very useful and nice video
Archana Bramhankar gffftt5tt oo
wah MAST
Good 👍👍
Thanks
Sir nice video
Sir one more requests if possible please publish a video regarding ms access deta relationship how to do it. If you have published then please share link.
Dear Sir,
Can you please explain me when I have data from numbers 1 to 100 but I want answers from between 50 to 100 with using sumifs formula
How can I show it in criteria
can you make a tutorial on taskade next?
How it was reading E3 i want to know that , how the F3 know that it must read from e3
nice video sir
Sir agar ham par criteria limited hai lekin sum and sumrange entry type mai hai usme daily entry hoti hai to sir uske liye kya kare please reply sir stock entry and consumption ke liye excel bana raha hu usme jarurat hai sir please reply anyone know
Good
sir by this formula just we can calculate tow items cauz i did 3 item the 3rd one was zero
plz share about macro
What if we need total OR Average of caps/Bikes in three different months, e.g. CAPS IN JAN, FEB, MAR (8+11+3) ?
use sum(offset(jan,feb,mar)
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)
Sirji, what is the formula for the Color font in a range in countif for ex: COUNTIF(L8:L23,"Green" but I am getting, range is L8:L28 I need green colored font
what if you want a total of both CAPS and BIKES? how to do that? thanks in advance sir
Sit VBA ke bare me ek video daliye please
How to use countifs fucntion which has multiple criteria ny using {}?
@@learningmagnet6252 thanks a lot sir.. I'm keen to learn.. 😂
@@learningmagnet6252 I'm sorry sir.. But that video not answer for my question.. My question is, countifs MULTIPLE criteria.. multiple in multiple..
Hi Rishabh is there any CD package available for your videos?
Pendrive Package available on www.excelsuperstar.org/excel-course-hindi-english-mix/
50% Discount on Full Advanced Excel Course
Should improve on explanation and focus more on the core of the formula, rather than what to select
And formula btaye
Sir,
Plz kindly make a video for Extract report " From Date :
End Date :
I followed some video but report Extracting with unwanted Date
or video bnaye plz send kre new formule k sath
Sir, excel me hum fraction kaise use krskte hai ?
Aap jo yha per fo jo lagta hai to kase legate hai plz