Prepare Report Using SumIfs Function | VBA Projects in Hindi

Поделиться
HTML-код
  • Опубликовано: 19 ноя 2024

Комментарии • 44

  • @AutomationFever
    @AutomationFever  3 года назад +1

    Download Excel Macro File For Practice 👉automationfever.com/single/iRMWvdjsRJg

  • @salilpattanayak7726
    @salilpattanayak7726 Год назад +1

    excelent project, nicely explained & logic, thanks

  • @nazarkamal8831
    @nazarkamal8831 Год назад

    This is the best video still now which I searching in RUclips regarding macro VBA excel excellent bhaiya from tamilnadu

  • @nazarkamal8831
    @nazarkamal8831 Год назад

    This is amazing I learned it thanks bhaiya ❤❤❤❤

  • @ashusharma9439
    @ashusharma9439 3 года назад +1

    You are truly great sir ❤️🙏

    • @AutomationFever
      @AutomationFever  3 года назад +1

      Thanks Ashu.

    • @ashusharma9439
      @ashusharma9439 3 года назад +1

      @@AutomationFever sir zoom par live bhi class lete h kya aap?🙏

    • @AutomationFever
      @AutomationFever  3 года назад

      No Ashu. Only youtube tutorials hi available h.

  • @ExcelMadeEasy444
    @ExcelMadeEasy444 3 года назад +1

    Nice Explained Sirji !

  • @jugnusingh4149
    @jugnusingh4149 2 года назад

    Thank you🙏🙏

    • @AutomationFever
      @AutomationFever  2 года назад

      You are most welcome. And thanks for your comment.

  • @jigneshpatel-bp2xw
    @jigneshpatel-bp2xw 3 года назад +1

    Very nice topic and explained good, keep it up for us sir ....

  • @khalednaser1657
    @khalednaser1657 11 месяцев назад +1

    Thank you for your feedback please also including sumifs with date range with multiple criteria

    • @AutomationFever
      @AutomationFever  10 месяцев назад

      You're welcome! I appreciate your feedback. I'll definitely consider creating content on SUMIFS with date range and multiple criteria. Stay tuned for that!

  • @nazarkamal8831
    @nazarkamal8831 Год назад

    Super

  • @makaniharesh1459
    @makaniharesh1459 3 года назад +1

    Easy to understand and great work
    🙏 Thank You
    Agar last row 10000 plus hai to kya ye work karega ??

    • @AutomationFever
      @AutomationFever  3 года назад

      Yes, However, i will suggest to use pivot table to summarize large data.

  • @khalednaser1657
    @khalednaser1657 11 месяцев назад

    Excellent Project, pls can you make this RUclips in English, so we can understand it.

    • @AutomationFever
      @AutomationFever  11 месяцев назад

      Thank you for the positive feedback! I'll consider making an English version of the video to ensure wider understanding. Stay tuned for updates!

  • @vijaysahal4556
    @vijaysahal4556 3 года назад +1

    Sir nice h sumifs method blog per aapse ek requst h isi same question per aap isi samr data main ek column or add kre date ka or condition bhi aapki sabhi but ek date greater than or lessthen extra condition krke plz bnaye

    • @AutomationFever
      @AutomationFever  3 года назад

      Bilkul bilkul ham jaror aesa ak video banayege. Par es week may be na ho paye. Next week m upload krne ki try krege.

    • @vijaysahal4556
      @vijaysahal4556 3 года назад

      @@AutomationFever ji bhai tq 👍🏻👍🏻👍🏻💯

  • @vijaysahal4556
    @vijaysahal4556 3 года назад +2

    Sir data set ka hint de rha hoon aapko taki mujhse mere projects main help ho sake
    DATE ,SALESMAN ,REGION , PRODUCTS, TOTALSALES
    HUMKO REGIONWISE OR PRODUCT WISE OR DATE GREATER THAN ND LESS THAN TOTAL SALES CALCULATE KRNA HAI SUMIFS THROUGH

    • @AutomationFever
      @AutomationFever  3 года назад +1

      Hi Vijay,
      Aaj hi eske liye video record ki hai. Editing ke bad kal tak may be upload krege. Agar Aapko apne project ke liye abhi code chahiye ho to aap hamare whatsapp number pe ping kr sakte. Hamara whatsapp number kisi bhi video ke description m aapko mil jayega. Thanks

    • @vijaysahal4556
      @vijaysahal4556 3 года назад +1

      @@AutomationFever ji sir thanku so much 👍🏻👍🏻👍🏻👍🏻

    • @vijaysahal4556
      @vijaysahal4556 3 года назад

      @@AutomationFever ohk m waiting sir

    • @AutomationFever
      @AutomationFever  3 года назад +1

      Will upload today around 4 PM. Thodi si editing bachi hui h. Thanks for waiting

  • @vijaysahal4556
    @vijaysahal4556 3 года назад

    Nice sir but isi question main reagion ke according or date ke according total sales calculator kriye but date greater than or lessthen dino ek sath

    • @AutomationFever
      @AutomationFever  3 года назад

      Sure. Try karte h ki next week me aesa ak video upload kr sake. Thanks

  • @AbdullaKhizamworld
    @AbdullaKhizamworld 2 года назад

    How about if i have a Table? where always Counta Cant Keep like 5-8. Table Down may Update With More Regioon or Products.

    • @AutomationFever
      @AutomationFever  2 года назад +1

      Then get last row dynamically and use in sumif formula. Thanks

    • @AbdullaKhizamworld
      @AbdullaKhizamworld 2 года назад

      @@AutomationFever Thanks, Possible to Help with Example? or code?

    • @AutomationFever
      @AutomationFever  2 года назад +1

      @@AbdullaKhizamworld Will try to provide you example soon. Thanks

    • @AbdullaKhizamworld
      @AbdullaKhizamworld 2 года назад

      @@AutomationFever Thank you

    • @AbdullaKhizamworld
      @AbdullaKhizamworld 2 года назад

      @@AutomationFever Waiting for and Update. Why don't you show this same one with Auto fill on Table so if there is a Table with Multiple Data, Still Sumif Copy Paste untill the last raw of the table.

  • @MrManu0709
    @MrManu0709 3 года назад

    HI.. If i need to add criteria 3, How can i do that?

    • @AutomationFever
      @AutomationFever  3 года назад

      It's similar to excel sumifs function, You can 3rd criteria same as 2nd criteria. Thanks

  • @vijaysahal4556
    @vijaysahal4556 3 года назад +1

    Ye to easy ho paa rha h but jese hi date greater than or lessthen condition extra krta hoon to result nhi aarha h so plz sir agr possible ho to dekhna aap

    • @AutomationFever
      @AutomationFever  3 года назад +1

      Bilkul possible hai. Jaldi hi aesi video aapko milegi. Aap logo ka hi ye platform hai. Hamne ye channel esi liye create kiya tha ki yaha pe apni knowledge share kar sake or aap logo se kuch seekh sake. Esliye kabhi bhi koi query ho aap bejhijhak bata sakte hai. Thanks

  • @saritabisht8707
    @saritabisht8707 3 года назад

    Fso chapter finish hoo Gaya sir

    • @AutomationFever
      @AutomationFever  3 года назад

      Ni abhi kuch lectures bache huye hai. Ye Kuch use cases hai jo ham beech beech m small small project m cover karte rhte hai.