SUMIF Formula in Excel in Tamil
HTML-код
- Опубликовано: 3 окт 2024
- This Tutorial is all about What is the difference between SUM & SUMIF formula and How to use SUMIF formula in EXCEL.
For Online Class: geomouse1715@gmail.com
Follow me on Twitter & Facebook
/ endlessknowled1
/ enlessknowledge
Click the Link below to learn. (Subscribe for more upcoming Tutorials)
10 Amazing Shortcuts You Aren't Using
• 10 Amazing Shortcuts Y...
How to use MACROS in MS Word in Tamil
• How to use MACROS in M...
How to Create a Data Entry Form in Excel in Tamil
• How to Create a Data E...
Top 10 Excel Shortcuts for Beginners
• Top 10 Excel Shortcuts...
Table of Contents in MS Word in Tamil
• Table of Contents in M...
List of Tables and Figures in MS Word in Tamil
• List of Tables and Fig...
VLOOKUP in Excel in Tamil
• VLOOKUP in Excel in Tamil
Recommended Pivot Table in Excel in Tamil
• Recommended Pivot Tabl...
Slicer in excel in Tamil
• Slicer in Excel in Tamil
MS Excel Pivot Table in Tamil
• MS Excel Pivot Table i...
MS Word Translate Document
• MS Word Translate Docu...
COUNTIF formula in excel in Tamil
• COUNTIF formula in exc...
Signature line in MS Word
• Signature line in MS W...
How to Insert Section Break in MS Word Tamil
• How to Insert Section ...
Excel Formula Basics in Tamil
• Excel Formula Basics i...
Excel Basics for Beginners in Tamil
• Excel Basics for Begin...
Excel Printing Page Setup in Tamil
• Excel Printing Page Se...
*****************
Drop your doubts and suggestions in the comments. Don't forget to Like and Share the Video.
MS Word Tutorial in Tamil
• Watermark in MS Word i...
PowerPoint Tutorial in Tamil
• PowerPoint Animation T...
******************
04:30 AM, Neenga intha video record panni irukeenga... what a hard work?!
Yepdi solringa
Window screen la time iruku
antha time silence ah irukum
Your way of teaching is super.... Even i used excel sheet in my laptop from last 7 years, to be frank i learnt lot today, i am going use this knowledge from now... Kindly keep doing this wonderful job... God bless you.. Keep growing....
,
Good
Anna super ah solli thareenga.video frequent ah upload pannunga.unga video moolama Nan niraiya therinjikitten.thanks a lot.neat and clear explanation.
Glad to hear that... I'll try to upload nanba...
Nice clarification 🎉
Romba Thanks sir!!! Ovvoruvar thevayai poruthu ungloda indha video ku madhippu so obviously I am very thankful to you forever
You're really amazing sir. Thanks for your efforts to teach us. Good examples 👍👏
your most welcome...Keep learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
your explanation is so good even primary school kid can understand. thank you, a lot please make more video, related to accounting.!.
Neega tech panara viedo la epdui bro doubt varum soo crystal clear as usual
Bro sila time formulas automatic ha change agathu athukku enna reason na Formulas option la Calculation options la Automatic select agama irukkurathu athuyum ninga unga style ha ellarukkum puriyura maathiri sonna ellarukkum romba useful ha irukkum bro. Because na oru time athu theriyama romba frustrate agitten apram tha epdiyo thedi kandu pudichen
Bro your videos are easy and clear Macro programming tutorial post pannunga
பாறாங்கல் என்று நினைத்ததை மண்தூளாக மாத்திட்டீங்க அண்ணா. 👍👌
Thankyou sir . (vera leval teaching)
superra puriyuthu bro... great job...
Glad to hear that brother... Keep learning more about excel important functions ruclips.net/p/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa
Nice explanation.
😊😊the way of teaching super brother 😊
சகோதரரே...எல்லா பதிவுகளையும் எளிமையான முறையில் சொல்லி தரும் தங்களுக்கு,நாங்கள் கைமாறு செய்வது எப்படி என்பதை கொஞ்சம் சொல்லுங்கள்..நன்றி
Superb ❤❤❤ very useful 😍
Thanks a lot 😊... Keep Learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
Clear explanation bro
04:30 AM, Hats of bro 💯🤘❤️
Thank you sir
Welcome
பாறாங்கல் என்று நினைத்ததை மண்தூளாக மாத்திட்டீங்க அண்ணா. 👍👌
U r so great
Thanks for the clear explanation....
Glad it was helpful!
Is sumif function and pivot table both are almost equal sir ??? i mean sumif function answers we can get it done through pivot table also right??please answer sir.
my understanding is for simple findings in short time we can use sumif function and for any presentation we can use pivot table to show the data in multiple view.
please guide whether my understanding is right or wrong sir. thank you.
Good teaching sir
Thank you
Romba thanks bro
Super pa nice explained
Good job
Thanks
I am regularly watching your programe it is very use to binners.
I tried sumif and select the one range and it shows some range 0. If I copy the same range and paste it, it will showing the correct range value. what is the reason?.
Note: I am using Excel in my mobile phone, how to control ker and alt+Cotto key.
Thankyou.
Clearly Explained = Clear understanding. Tq so much the video.. keep rocking ..
HOW TO PREPARE DAY BOOK IN EXCEL. PLEASE UPLOAD A VIDEO FOR DAY BOOK ENTRY
Bro the excel use posting is it advanced excel or basic knowledge about excel
It's like same process like pivot ? It's my dout.....
Thanks brother.
You're welcome!
Super 🙏
Thank u bro
BRO , IF ANTHA "EAST" DATA MULTIPLE SHEETS IN SAME EXCEL AH IRUNTHALUM WORK AAGUMA?
Sir Google sheet functions solli kudenga sir please please please sir
Crystal clear explanation. Very useful for all
In which situations we have to use if conditions?
If formula and drop down list and sort functions Google sheet ley solli kudenga sir please please pls sir
Sum if and vlook up and slicer like same?
I need to sumifs function how use one sheet to another sheet kindly clarify
I am working in a steel hardware and traders it has 50 more supplier. on an average maximum 30 suppliers taking materials on daily basis. I need excel formulas for daily & monthly report for every suppliers pls help for this
Sir super
Keep Watching....
Sir,
=Sumif(region,east,total series)
Enakku 0 answer varuthu.
Na enna mistake pannenu theriyala.
Please reply me sir
nice sir
Keep watching
Bro salesperson , region etc cell le oru sinna down arrow mark irukku...athe epdi remove and add panrathu......athu name enne ...I forget it
nice sir
Thanks and welcome
Bro ms word la epadi alignment panrathunu video podunga
Bro en lap top old version so old version epd use panrathunu sollunga
Good evening sir. Student result ல் A grade B grade பிரித்து பார்ப்பது எப்படி?
you can try filter... ruclips.net/video/FTCGogCl9q4/видео.html
3.00 la Broo sumif(range, criteria, sum range ) la criteria vandhu ninga ninga seperate ah type pani vecha east ah click panadhuku instead ah region la iruka oru east ah click panna support aguma?
No
bro namma serach panra criteria la andha specific word ku apparam space iruntha adhu select aaguma? eg- we are searching east in criteria but in that list it is east(space) will it take that value or not?
bro 1000 fill handle option vachi 2000,3000 maatha mudiuma because enaku fill series kudutha 1001,1002 varudhu
Anna unmayave neega vera level..enaku exam iruku so indha ella videos ume romba useful uh iruku..engada teachers kooda ivlo theliva solla mataga..hats of you..❤from sri lanka
Excellent Skills and High level Teaching , Thank you sir.
How to create own
The teaching method is very 👍... congratulations 🎉 keep it up.
Anna, Pivot table ae indha job ah seiyum thaana...?
Bro neenka solra keys la sila keys laptop kku work aakamaattuthu athanala vera keys iruntha sollunka plzzz
Anna enaku same formula la yes, no and Na apdingara option ah matum count pananum.
Just upload the index, match, offset formulas.
Bro how can we find a person sales different regions? Ex. Ramesh sales in the east, west, north and south in one formula
Reply please
Use pivot table nanba...
@@EndlessKnowledge thanks for your reply...😊😊😊😍
Sir unga videos ellama romba usefull ah iruku sir
Bro pls help.. I want number of cases How To find?
I saw all your videos excellent great 👍 excellent presentation
Anna early morning 4.30 AM ku record paningala
hats off for your hard work
Yes, in my beginning stage... i have to work and also i have to build this channel... I've just put minimum effort but god helped me... Everything god's grace...
Bro one product 100 numbers serial number like 20J130A00001, 20K35A00007, 20J130A00009, 21J35A00010.THESE NUMBER I WANT TO COUNT USING MIDDLE LIKE 35A OR 130.HOW TO DO TABLE FORMULA.
Intha EXcel Sheet Kidaikkuma? Neenga Practice Use pannara Excel Sheet Kidaikkuma?
was going through sumif , have a doubt , sumif / vlook / pivot table through all we get the same result right ? then y are we using all different formulas instead we should use any one of these formula
am just a beginner in the excel , question just pop up in the mind
Super teaching sir
Your teaching is very Nice sir...🥰 Do you have visual basic videos😒???
not now but soon... Keep learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
Ok Thanks For your response sir.🥰
Bro idhuku pivot table kuda ok dhana bro
yes...
Tq so much 😊
Sir I have doubt sorry for this question
We are use to filter answer are show on. Then why I have do this furmula..
But teaching is good 👍
Thank you sir. Please explain how to use standard formula for totalling date-wise debit and credit columns and balance in next line, like cash book in tally.
நாம எப்படி கண்டுபிடிக்குறது இந்த Formula எதுக்கு அடுத்த formula எதுக்கு அப்படி கண்டுபிடிக்குறது எப்படி அண்ணா
அண்ணா
Bro cloumns la epidi bro onu ona minus pannurathu
Ex:
10
-2
=8
-3
=5
Ethu maththiri epidi bro automatic ahh vara veikkerathu
what is the difference between sumif and vlookup
Instead of using sum if,we can use pivot table.easy
Sir,HOW TO CREATE AUTOMATIC ATTENDANCE SHEET IN EXCEL?
Will upload soon
Sir unga viocela kaekumpodum
Puriyuthu
And
Interestaa irukku
Easy. I have searching good pdf converter with all platform in same..🎉
great try this ruclips.net/video/ugIrbJSDY2E/видео.html
Sir intha table sumif formula ethuku use pandrathu.....
Ithu pivot table oru mari thana iruku...
bro ,,sumif is not workout me ,what i do ,give any idea
இடையில் இருக்கும் சில விட்டு விட்டு கூட்ட வேண்டும், எளிதான வழி உள்ளதா சார்?
Perfect explanation!
why it shows me 0 for every calculation in this format
தம்பி....பிவெட் டேபிளுக்கும் இதற்கும் என்ன வித்தியாசம்
Bro ethula value nu oru error varuthu atha eppadi solve pandrathu bro
Brother, kindly check the formula you typed and also check the cells you are referencing... Keep Learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
Bike finance pathi videos podunga bro
First answer Aprm copy pannumbodhu answer thappa varudhu sir.
What may be the reason??
Plz reply sir
Do not copy just Drag using the Fill handle...
Only order's... method display
Bro ennaku vanthu intha data la (RAJESH VANTHU WEST TOTAL ha evlo sale pannru nu answer vesnum) so please replay this comment bro😢😢😢😅😅😅
AND ORU DOUBT ANNA DIFF BETWEEN SUMIF AND COUNT IF...
Supper bro மிகவும் நன்றாக சொன்னீர்கள் 👍👍👍
Bro nenga enna system use pandringa
Thanks anna class poi kooda vilangalla itha paathathum than vilangichu
Brother if I am supposed to find that a person who has done sales in East, West, North, South separately in simultaneously how to find out ?
Brother ungaloda videos ella ippodha paaka start panniruken really awesome easy aa puriyudhu knjm tally erp 9 kum tutorial videos upload pannunga brother....plz....
Ok anna but name, and region enna orey matheriya kudutha kudupanga oruvela Mari Mari name vandha athavathu athey name ellama mathiathi vandtha answer varuma? Doubt ta eruku