Тёмный

VLOOKUP with TRUE and $, SUMIFS (Multiple Criteria) 

Excel Superstar
Подписаться 385 тыс.
Просмотров 19 тыс.
50% 1

In this tutorial, we'll show you how to calculate bonuses for dealers in Excel using Vlookup and advanced SUMIFS formulas.
Check out our 21 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
🔗 Download Practice file - bit.ly/34qyhnl
✅ Learn Vlookup Formula in Excel - • Excel VLookup Formula ...
✅ Learn SUMIFS Formula in Excel - • Excel SUMIFS and COUNT...
✅ Learn Excel Cell Reference ($) - • Excel Cell Reference -...
VLOOKUP with TRUE and $, SUMIFS (Multiple Criteria)
#Vlookupformula #SUMIFSformula #excelformulas
To watch more videos visit: www.excelsuperstar.org/​​​​​​​​​
To Buy an Excel Course visit: www.courses.excelsuperstar.org
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

Опубликовано:

 

9 мар 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 48   
@VipulJain40
@VipulJain40 2 года назад
Excel Teaching ke Bahubali 🙏
@pradeepjangid490
@pradeepjangid490 2 года назад
Being proud to be a subscriber of this channel.
@rithikgodimani6385
@rithikgodimani6385 Год назад
God bless you Rishab sir ♥️
@sawanbarche3223
@sawanbarche3223 2 года назад
Apki video dekhne k baad mere ghanto ke kaam minto me nipat jate hai bahut bahut dhanywad
@Kamimehar10
@Kamimehar10 2 года назад
Awesome, ThankYou Sir
@TravelAdventure-India
@TravelAdventure-India 2 года назад
Exceptional Knowledgeable Video.....🙂
@rukhsarsheikh4735
@rukhsarsheikh4735 Год назад
Dear Rishab, Thanks for enhancing my excel skills. You are awsome ❤ the way you teach the detailing all persuade me to give you prayers. May you have healthy life with all the successes
@karteekk6905
@karteekk6905 2 года назад
Like everytime we said you have best teaching skills !
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks again!
@princemurali2009
@princemurali2009 Год назад
Very useful
@ruchaj.5550
@ruchaj.5550 2 года назад
easy, clear and simple learning...as always you are a true superstar ,thanks for sharing and making India grow
@abidejaz1090
@abidejaz1090 2 года назад
Thanks again ap ki pichli video se mera aik bht bara masla solve hua hai thanks again dear ☺
@gilchirstadam9813
@gilchirstadam9813 2 года назад
Well done
@RakeshKumar-hc3gc
@RakeshKumar-hc3gc 2 года назад
Nice
@sahiranwar7856
@sahiranwar7856 2 года назад
Thank you sir for making this video Aapke wajah se mera MIS banne ka chances or badhte jaa rhe h Thank you so much sir ❤❤
@chetnawadhwa4345
@chetnawadhwa4345 2 года назад
Thank u for ur knowledgeable and easily understanding video
@AmitGupta-bl2iu
@AmitGupta-bl2iu 2 года назад
You are India's 🇮🇳 best Mentor😇😇
@hariomjaiswal5789
@hariomjaiswal5789 2 года назад
Thank you so much Sir 🙏 for the really useful video 🙏
@PrashantKumar-im5ri
@PrashantKumar-im5ri 2 года назад
superb
@pawangupta056
@pawangupta056 2 года назад
keep on posting such video :)
@mamalik1088
@mamalik1088 2 года назад
Super nice
@DineshSardesai
@DineshSardesai 2 года назад
Great
@devangthakkar6847
@devangthakkar6847 2 года назад
Excellent sir
@raipururban2450
@raipururban2450 5 месяцев назад
Very nice can plz share video sumif with vlookup
@vijayarjunwadkar
@vijayarjunwadkar 2 года назад
Super useful technique Rishabh, thanks for sharing! This will help me in my analysis work a lot! 😊👍
@muhammadjaleel531
@muhammadjaleel531 2 года назад
Thankful
@mohammedsufiyan8794
@mohammedsufiyan8794 2 года назад
Real Superstar💪🏻
@msofficetutorials4411
@msofficetutorials4411 2 года назад
Thanks You
@kseopeneducation
@kseopeneducation 2 года назад
Very helpful vedio
@SHEERAZ-ALI
@SHEERAZ-ALI 2 года назад
Very nyc sir ji mene Apke videos se hi buht kuch seekha hy Me apko bata na chahuga k more then equal long ">="&cell k bajaye ap Ese bhi lekhege to asan hoga >=1-Dec-19 criteria me
@rishabhpugalia9281
@rishabhpugalia9281 2 года назад
Cell ko refer karne se formula dynamic ban jaayega. Anyathaa, woh static reh jaayega
@SajidAliSyed
@SajidAliSyed Год назад
ThankQ Rishabh, Request you to plz suggest where i can learn powerBi advance technique and tricks
@prashantgupta2172
@prashantgupta2172 2 года назад
Rishabh bhai, plz 5 case study power query wali data sheet send kar digiye, ya uska link description me daal de, plz bhai bhaut shandar vedio tha but practise ke bina bekar he
@dhaneshwarsahu5216
@dhaneshwarsahu5216 2 года назад
sir! I want to you have make video for use of special caracter sign in where we use defrent function in excel formulas.
@sandeepdange7077
@sandeepdange7077 2 года назад
Sir any video on pie chart
@muzaffarshaukat3416
@muzaffarshaukat3416 Год назад
Hi Rishab, hope you will be fine. I really like your videos and excellent method of teaching. I have a query, I want to extract unique characters between two strings, can you help me in this regard example string1 is 123456 and string2 1245 the answer should be 36
@suyogpathak9897
@suyogpathak9897 2 года назад
Hi Rishab sir aapke pass VBA macros ka course available he kya pen drive ke through
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Nope, only online access via our site
@suyogpathak9897
@suyogpathak9897 2 года назад
@@ExcelSuperstar ok thanks 😊
@pankajjain5916
@pankajjain5916 2 года назад
Hi Rishabh, I have one problem of which I am not able to get the answer: Two duplicate codes in one column and against codes there are different values, currently shown vertically. I want to show the values against codes horizontally. But not able to do so.
@pankajjain5916
@pankajjain5916 2 года назад
@PJ facts Code. Rec type 101 CO 101 OT
@pankajjain5916
@pankajjain5916 2 года назад
I want to display it horizontally so that I can use V-lookup with some other date
@chandramohan1418
@chandramohan1418 2 года назад
I have used SUMPRODUCT instead of sumifs.
@samuelpurification3530
@samuelpurification3530 2 года назад
Can't see
@madritjanaki1009
@madritjanaki1009 2 года назад
Make it in English
@fatihyldz8199
@fatihyldz8199 2 года назад
please in english......
@mubeensarfraz1731
@mubeensarfraz1731 Год назад
Nice
@NAVEENSHARMA-ss5vy
@NAVEENSHARMA-ss5vy 2 года назад
Nice
Далее
7 Ways to Use Vlookup in Excel
16:44
Просмотров 2,7 млн
sumifs between two Dates and another criteria
10:06
Просмотров 49 тыс.
How to Use VLOOKUP in Power Query | Goodly Hindi
8:05
Просмотров 1,8 тыс.
Vlookup with Duplicate Entries
6:23
Просмотров 60 тыс.
Which Excel formula to use WHEN❓ (Excel in Hindi)
5:55
Vlookup in Excel | Vlookup formula with an example
6:54