SUMPRODUCT formula in excel in Tamil

Поділитися
Вставка
  • Опубліковано 10 гру 2024

КОМЕНТАРІ • 208

  • @mathumkp9371
    @mathumkp9371 4 роки тому +6

    The habit of making known to unknown is a boon for some people. You are such one. Best wishes for all success in all efforts.🙌

  • @abrahamb8783
    @abrahamb8783 4 роки тому +5

    Sir, your teaching is very perfect. I understand very easily

  • @fazilahamed7636
    @fazilahamed7636 3 роки тому +2

    Interesting brother.... Super ah panringa sum if countif sumproduct ithukkalam enna difference irukunu sollamaye nalla puriyuthu thank you🙏 excel tutorial... Full ah pathutuu varen 😊

  • @mohamedashik1017
    @mohamedashik1017 4 роки тому +2

    It is the first time I heard about sumproduct,
    Also it is very useful👍👍

    • @EndlessKnowledge
      @EndlessKnowledge  4 роки тому

      yaaa.... if you master the SUMPRODUCT Function ... you don't have to use Sumifs, Countifs, Hlookup or Vlookup.

  • @sudhametilda5857
    @sudhametilda5857 2 роки тому +1

    Thank u sir ,your videos are very useful and easy understandable.

  • @harishkumar-vr3yx
    @harishkumar-vr3yx 4 роки тому +3

    Excellent brother, thank you so much for uploading these videos

  • @welcometamilan9886
    @welcometamilan9886 2 роки тому +1

    fantastic your explanation I can understand it very very easy, thank you sir

    • @EndlessKnowledge
      @EndlessKnowledge  2 роки тому

      glad it was useful to you... keep learning more ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @mohammedarafath3342
    @mohammedarafath3342 2 роки тому

    super bro unga videos romba usefulla irukku na unga ella videosum papen , and work panni pakka practice sheet kudutha romba useful la irukum

    • @EndlessKnowledge
      @EndlessKnowledge  2 роки тому

      Glad to hear that brother... Some tutorialsuku practice file provide panirpen but will try to provide for every tutorials...

    • @mohammedarafath3342
      @mohammedarafath3342 2 роки тому

      @@EndlessKnowledge yes some videos have practice file... thank you for your reply

  • @bkcinimascopeofficial
    @bkcinimascopeofficial 9 місяців тому +1

    Thanks Anna you make my day useful

  • @52ramiyer67
    @52ramiyer67 Рік тому

    You are an excellent teacher sir. God bless you

  • @jashwinthmedia3116
    @jashwinthmedia3116 4 роки тому

    Bro supera explain paninga, All formulas need bro advanced excel formulas,.

  • @Smsenthilkumar6
    @Smsenthilkumar6 5 місяців тому

    Thank you for the wonderful video sir.
    Kindly explain the difference between sumif and sumproduct.

  • @balajikumar7683
    @balajikumar7683 4 роки тому

    Thanks for ur clarification video on sumproduct i was expecting very long time

  • @farshadrafeek2827
    @farshadrafeek2827 3 роки тому

    Superb one, Eager to learn more from this channel.

  • @bavadharanim8360
    @bavadharanim8360 3 роки тому

    Hi bro ur teaching very helpful to me

  • @maheshk9265
    @maheshk9265 3 роки тому

    Thank you so much for your valuable information 👍

  • @sathyanarayanansatagopan9069
    @sathyanarayanansatagopan9069 3 роки тому +2

    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.

  • @rajasekarv2517
    @rajasekarv2517 4 роки тому +2

    This video is amazing bro when are you making for photoshop tutorial? I am eagerly waiting for this tutorial. Again super bro.

  • @sethumanoharan6051
    @sethumanoharan6051 10 місяців тому

    I learned lots of things from your video

  • @ssattanathan79
    @ssattanathan79 Рік тому

    Your teaching ways are Excellent. I am not aware of most of the functions in Excel, Word, or Outlook. Learning a lot from you. Thank you so much for your teaching. In this video, I found a check tab in Excel with different buttons and when you clicked it opened the data how do you create this Check Tab Brother.

  • @bsenthilkumar2634
    @bsenthilkumar2634 4 роки тому

    Excellent Job bro
    Teaching method is good

  • @ammukutty13477
    @ammukutty13477 3 роки тому

    Sir....ur always uses Alright ohhhhh..Nice

  • @mohammedtariq6110
    @mohammedtariq6110 Рік тому

    Thank u for this amazing tutorial in Tamil

    • @EndlessKnowledge
      @EndlessKnowledge  Рік тому

      You are welcome 😊... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @johnjames-wn4fx
    @johnjames-wn4fx Рік тому +1

    Power pivot basics la irunthu start panunga bro

  • @likeone8539
    @likeone8539 4 роки тому +1

    Hiii..Sir, you are explaining very well & I like your video's but I need know how to creat DRR report in 5 star hotels.

  • @saiaadhiya5161
    @saiaadhiya5161 4 роки тому +6

    Sir, waiting for your MS Access class

  • @marans22
    @marans22 4 роки тому

    Your all tutorial are amazing

    • @EndlessKnowledge
      @EndlessKnowledge  4 роки тому

      Thank you...

    • @marans22
      @marans22 4 роки тому

      @@EndlessKnowledge make it for me
      Present-day full day +HL half day = 1.5 day
      That's what I learn

  • @mohamedfaisel3032
    @mohamedfaisel3032 3 роки тому +1

    hi, bro very useful class to all people and please clarify one doubt can u explain that check sheet how to create the many filters to select one by one. please explain

  • @gaudhamanparamanandam8268
    @gaudhamanparamanandam8268 4 роки тому

    excellent sir. put video in automatic sheet copy in to next sheet in excel

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 3 роки тому

    good job. Put excel practiced files in the description.

  • @subinraj-youtubechannel2760
    @subinraj-youtubechannel2760 3 роки тому

    Its very useful Thanks sir

  • @saranyadurairajsaikrishna4176
    @saranyadurairajsaikrishna4176 4 роки тому

    Sum um varathu.... product um varathu... nice dialogue bro

  • @SatishKumar-ik6vm
    @SatishKumar-ik6vm 4 роки тому

    Super sir and voice also very nice, while explaining in system please zoom the video some I can't see🙏

    • @EndlessKnowledge
      @EndlessKnowledge  4 роки тому +1

      Sure... Kindly increase the quality while watching the video...

  • @sethumanoharan6051
    @sethumanoharan6051 10 місяців тому

    Your our teacher

  • @muruganp007
    @muruganp007 4 роки тому +1

    Extraordinary teaching sir. Please upload more videos....
    Can you explain the check sheet filter macros...

  • @johnrockin0076
    @johnrockin0076 4 роки тому

    Nice . thank you souch sir.
    Can you do video about google spreedsheet please.

  • @mohammedsadam5600
    @mohammedsadam5600 4 роки тому

    Nice Explanation Bro

  • @ajithkumar-uu5hm
    @ajithkumar-uu5hm 4 роки тому

    Thanks Brother..👍🙏

  • @lakshmikanthanramas2444
    @lakshmikanthanramas2444 4 роки тому

    Useful video Sir, thank you

  • @gopinathn24
    @gopinathn24 3 роки тому

    No comment, clear

  • @RamKumar-fs9sd
    @RamKumar-fs9sd 4 роки тому +2

    Bro. Could you please explain third tab(check) sheet? How you prepared that?

    • @thanipattavan
      @thanipattavan 3 роки тому +2

      Bro that is called slicer. Once you make the Pivot Table or Table, go to insert and select slicers and chose the data you want to use as a slicee

    • @mohans830
      @mohans830 2 роки тому

      @@thanipattavan can u make the video bro about slicer.

  • @elayalathacookingeatingcha4869
    @elayalathacookingeatingcha4869 4 роки тому +1

    Sir, please explain check sheet working

  • @gnanasekar4763
    @gnanasekar4763 5 місяців тому

    bro excel very teach very well but sum product again please one more time explain for me
    confuse for advance sum product

  • @PodaVennai-p2b
    @PodaVennai-p2b 4 місяці тому

    Super super super........
    Chatgpt kude inthe conditions se solle mudiyale... Neenke sollitinke....

  • @bavadharanim8360
    @bavadharanim8360 3 роки тому

    Pls less than greater than use pandra madhiri edhavadhu formulas irundha pls video podunga bro

  • @baskaranvaradhan2369
    @baskaranvaradhan2369 3 роки тому

    Super 🙏

  • @yasoabi1091
    @yasoabi1091 3 роки тому

    Hi bro na unga Ellam video na parthutu iruken enaku Avarge formula thaniya video potunga bro

  • @vardhinijayakumar7182
    @vardhinijayakumar7182 Рік тому

    Bro ennum koncham sumproduct pathi detail la soluga

  • @srikanthjey9403
    @srikanthjey9403 4 роки тому

    Hi Bro,,, Thanks,,, Could you please make the video for Family tree for office organization

  • @KokilaHarish-bo5ez
    @KokilaHarish-bo5ez Рік тому

    Super and thank you

  • @gangadharan5965
    @gangadharan5965 4 роки тому

    Thank you for the video bro

  • @gokulnathkandasamy3286
    @gokulnathkandasamy3286 4 роки тому +1

    Bro could you make a session for how to make drop downs

  • @gururaghavendran7794
    @gururaghavendran7794 4 роки тому

    Nice work

  • @manoharanpjs3905
    @manoharanpjs3905 3 роки тому

    Sir please continue Excel video

  • @veerakumar8630
    @veerakumar8630 4 роки тому

    good explaining..sir value ahh wordku spell pandra formula epdinu solluga sir

  • @bobby25029
    @bobby25029 3 роки тому

    Sir Put up a video for monthly buyer and sales account registration

  • @masoodmohamed4270
    @masoodmohamed4270 4 роки тому

    வணக்கம் நான் உங்களுடைய ஒவ்வொரு வீடியோ மிகவும் மிக்க மகிழ்ச்சி வாழ்த்துக்கள் எனக்கு ஒரு சிறிய சந்தேகம் சம் பார்முலா நீங்கள் சொல்வது எனக்கு கொஞ்சம் புரியவில்லை நான் ஈ மெயில் அனுப்பி இருந்தேன் எனக்கு ஃபெயிலியர் நோட்டீஸ் நம்முடைய உதவி எனக்கு தேவை எனக்கு உங்களை எப்படி கரெக்ட் பண்ணுவது என்பதை எனக்கு தெரியப்படுத்துங்கள் நான் உங்களை

  • @vinothc6393
    @vinothc6393 4 роки тому +1

    Bro graph yepudi podanum sollunga means x axis 2 value and y axis 2 value iruka Mari basics to difficult varikum iruka marai sollunga quick ah podunga videos bro final yr projects ku use agudhu bro

  • @prabudevak2455
    @prabudevak2455 4 роки тому

    Thank you bro....

  • @sathish2522
    @sathish2522 4 роки тому

    Good one..sir your nature of work?

  • @voldemort481
    @voldemort481 2 роки тому +1

    Amount sum : Sumproduct formula use pannama sum formula use panni identify panna mudiyatha bro?

  • @BHARATHKUMAR-cr1vv
    @BHARATHKUMAR-cr1vv 2 роки тому

    Excellent sir,How can i reach you sir please

  • @vincilinmary4450
    @vincilinmary4450 2 роки тому

    Do a vedio for Bill Of Material

  • @manoj.s9638
    @manoj.s9638 4 роки тому +2

    Bro how to edit a video with filmora software full tutorial sollunga bro

    • @venkatesh_Vsh
      @venkatesh_Vsh 4 роки тому +1

      Bro kine master power director app use pannunga bro nalla erukkum

    • @manoj.s9638
      @manoj.s9638 4 роки тому +2

      @@venkatesh_Vsh ella bro basic kaaka naa filmora keten bro thanks for ur suggestion bro

    • @EndlessKnowledge
      @EndlessKnowledge  4 роки тому

      Sure nanba... a video will be uploaded soon...

  • @yesuraja200
    @yesuraja200 4 роки тому +1

    sir Goodevening, how to use OR & AND function ?

  • @UmersalmanMA
    @UmersalmanMA 7 днів тому

    excel should be pinned in comments for practice

  • @hussainfawzer
    @hussainfawzer 4 роки тому +1

    Bro do indexmatch function

  • @vaishuvenkats9959
    @vaishuvenkats9959 4 роки тому

    Hi anna... Can u make cell reference. Like absolute and relative and mixed reference... Itha pathi konjam video podunga anna please🙏🙏🙏...

  • @dayaramt.p.8459
    @dayaramt.p.8459 2 роки тому

    Explain how to use NHM writer and Convertor

  • @sivakumar-dd9oo
    @sivakumar-dd9oo 4 роки тому

    SUPER SIR

  • @lovely2kmurali561
    @lovely2kmurali561 3 роки тому

    Super bro

  • @santhoshkumarm6493
    @santhoshkumarm6493 3 місяці тому

    Rice oda quantity find panna, sumif use pannalame?

  • @praveenm4319
    @praveenm4319 10 місяців тому

    How u got 3 bro ? How deleting reference for Quantity column results count (i.e: 3) ?

  • @vigneshpandian834
    @vigneshpandian834 3 роки тому

    Keep it up

  • @Mohamed_ibrahim_skm
    @Mohamed_ibrahim_skm 4 роки тому

    Super

  • @gowsia2202
    @gowsia2202 4 роки тому +1

    வணக்கம் சகோ, Ms EXCel Exam point of you ல எதெல்லாம் Important Please make bro, I Will Prepare MHC Exam. Please help me

  • @sammuthu8234
    @sammuthu8234 3 роки тому

    Hi bro, nenga online class edukengala

  • @Vinothkumar-yk3cm
    @Vinothkumar-yk3cm 4 роки тому

    Sir I need one doubt plz clarify to me.
    Oru cell la oru number type panura po sum use pani atha mulitify pani poda mudiuma for ex oru cell la 25 nu type pana 4 multify agi 100 nu varanum antha cel la

  • @keepsmile8758
    @keepsmile8758 4 роки тому +1

    Bro how calculate RS.120 multiple in tax but they shown in #value😓

  • @rajesha3520
    @rajesha3520 4 роки тому

    ithu nenga sum if la panidalamey? to find rice quantity

  • @mathipnr
    @mathipnr 3 роки тому

    Sir How to convert downloaded bank account Number to the number format

  • @data_analyst157
    @data_analyst157 Рік тому

    ... sir how do create the option box ? Teach it

    • @EndlessKnowledge
      @EndlessKnowledge  Рік тому +1

      um which one?

    • @data_analyst157
      @data_analyst157 Рік тому

      When you teach sumproduct , you was got another excel sheet how choose that option ( company, month,year ) ?

  • @arulrajrajendiran7020
    @arulrajrajendiran7020 6 місяців тому

    How to split excel data in separate sheets or new excel book

  • @victorleela6823
    @victorleela6823 4 роки тому

    Check epdi use panniga Bro

  • @vishnupriya5044
    @vishnupriya5044 11 місяців тому

    Sir starting la sumproduct find panigala sir apo multiply (*) tharama comma(,) tharenga sir

  • @n.rameshbe-ece6087
    @n.rameshbe-ece6087 2 роки тому

    Kindly give same excel in description

  • @Srivanisareswathy07
    @Srivanisareswathy07 6 місяців тому

    U don't say how quantity countbis 3, after changing quantity sum ?? 11:11 11:13 how u didn't explain??
    Quantity ?? How 11:40 11:41 divide by /17 ???

  • @MaheshKrishna-e2k
    @MaheshKrishna-e2k 3 місяці тому

    Sir video end la neenga check pannumbodhu keela oru filter vandhchu adhu epdi pannanum sir

  • @dj.jerlinjerlin9186
    @dj.jerlinjerlin9186 2 роки тому

    Good morning sir i didn't understand Quantity average can you help me?

  • @saravanansaravanan6365
    @saravanansaravanan6365 3 роки тому

    Anna entha videola oru doubt quantity 3 epdi soltringa any exames I mean avarage calculate pannumpothu

    • @saravanakumarm4299
      @saravanakumarm4299 Рік тому

      bro normal condition mattum apply panni irukkaru company(mrf + ceat), month (march), year(2022), entha oru calculation kudukala athunala , in 2022 march month (mrf,mrf,ceat) so 3 show in result

  • @ramkumarg4928
    @ramkumarg4928 2 роки тому

    Bro Need for tutorial subtotal + sumproduct

  • @muthumariammantempleindhir9860
    @muthumariammantempleindhir9860 3 роки тому

    How to prepare the check sheet, pls explain sir

  • @vijinatarajan6220
    @vijinatarajan6220 3 роки тому

    How are you getting quantity 3,pls explain

  • @hihello5226
    @hihello5226 4 роки тому +1

    Bro, Check sheet epdi create pannanum

  • @nambirajanv
    @nambirajanv 3 роки тому

    Bro, how to put absolute cell reference from one sheet to another sheet

  • @_Spidy_Gaming
    @_Spidy_Gaming 2 роки тому +1

    Yaarellam sirichinga 4:37 la

  • @vigneshwarim446
    @vigneshwarim446 Рік тому

    How to get quantity count sir

  • @sooryasoorya6239
    @sooryasoorya6239 Рік тому

    Rs. Symbol la epdi add panninga amount columnla

  • @ganesanramamoorthy4875
    @ganesanramamoorthy4875 3 роки тому

    What is check file sir

  • @jmnusky9467
    @jmnusky9467 4 роки тому

    Why we cant use sumif's formula For the same process....?