MS Excel - How to use MAXIFS to get the max value with text criteria referenced in cells [Must Know]

Subscribe to our Learning to Excel channel for more videos like this! These videos will help improve your professional knowledge, productivity and efficiency. By subscribing, you can also contact the Learning to Excel team directly so that we can personally help you with your own specific MS Excel queries and problems. MS Excel - How to use the MAXIFS function to get the maximum value based on text criteria referenced in cells 0:00 Intro 0:07 MAXIFS formula & example 0:28 MAXIFS ranges and criteria 2:00 MAXIFS result 2:08 MAXIFS referencing cells 3:19 Outro Let us know in the comments what MS Excel video you'd like to see next! CONNECT WITH US: Website: COMING SOON! Instagram: https://www.instagram.com/learning_to_excel/ Some links may be affiliate links. We may get paid if you buy something or take an action after clicking one of these. Learning to Excel YouTube Channel is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. As an Amazon Associate we earn from qualifying purchases. AFFILIATE LINKS: Looking for a cheap but high-performing laptop? Learning to Excel uses the HP EliteBook 840 G6: https://amzn.to/45fZmnc OTHER RECOMMENDED VIDEOS: COUNTIF less than value: /watch/MD_4rZtb2qRb4 SUMIF based on text: /watch/8PIiMSTfHbcfi AVERAGEIF based on value: /watch/0KVV_wfk2MbkV MINIFS based on text: /watch/kufBmEAiIM6iB MAXIFS referencing text in cell: /watch/w5yjVBKoeSvoj Excel Keyboard Commands: /watch/0zg9-64MKQkM9 Conditional Formatting based on text: /watch/MSEe2PKdDYMde Sort Excel tables based on text: /watch/87Gf1Nit5rTtf SUMPRODUCT Fee Table: /watch/U8k_gEucrdyc_ Lock & Protect cells: /watch/QLnBomBY72nYB RECOMMENDED PLAYLISTS: MS Excel - COUNTIF: /playlist/PLV-WqGjrV95wd7dqtSTR8RRHGP5wCdGdh MS Excel - SUMIF: /playlist/PLV-WqGjrV95xm4jAJyxEff6P-o1KOQgev MS Excel AVERAGEIF: /playlist/PLV-WqGjrV95yMH5NKUZfr3YMVOZPEC_h1 MS Excel - MINIFS: /playlist/PLV-WqGjrV95zPl9Uko2yJemPBm_kaaweG MS Excel - MAXIFS: /playlist/PLV-WqGjrV95zmq0Em18IVa0IOShBGMKjM MS Excel - Keyboard Commands: /playlist/PLV-WqGjrV95z5pUAjAOsrjzebEQmHVfyM MS Excel - Conditional Formatting: /playlist/PLV-WqGjrV95zbuCzfFarK1TnGSfMntvyV MS Excel - Sort: /playlist/PLV-WqGjrV95wt7jvEEHWrH7LtccnPGU3g MS Excel - SUMPRODUCT: /playlist/PLV-WqGjrV95xLLVnlHbQBCDJxXIn7kXSc MS Excel - Lock & Protect: /playlist/PLV-WqGjrV95y-krAEGOwinuoLOskHtMiL AFFILIATE LINKS: Want easy Passive Income? We here at Learning to Excel are partners in the Crypto Cash Flow Partner Program and earn easy passive income. Join us via this link: https://3cba8hz2z6rywhr-p8vbkrko02.hop.clickbank.net/?tid=Crypt1 Want MORE easy Passive Income? Here at Learning to Excel we are invested in the top returning dividend stocks and earn easy passive income as a result. Join us via this link: https://7ac4dp-yy9t--fhi0bf3-p1k54.hop.clickbank.net/?tid=Div001 Let us know in the comments what MS Excel video you'd like to see next!

Category