HDTutorial
EN
How To Sum Multiple Columns Based on Criteria(s) | Excel Tutorial Video

The creator does not allow this video to be played on other websites. You can watch it directly on YouTube.

How To Sum Multiple Columns Based on Criteria(s) | Excel Tutorial Video

93,957 views October 26, 2018 5:40

Watch on YouTube
ChannelJie Jenn

Description from the creator

Sometimes you may need to sum multiple columns based on one criteria or more criteria. In this Excel tutorial video, I am going to demonstrate how to use SUMPRODUCT() function to sum multiple columns when your criteria matched.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
☕ Paypal: paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: join.robinhood.com/jiej6

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: patreon.com/JieJenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
🗓 Get updated on new Python videos → facebook.com/MadeInPython/
📘 More tutorial videos on my website → LearnDataAnalysis.org
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: bit.ly/3B1DjSA
✉ Business Inquiring: [email protected]

About this tutorial

Jie Jenn published this 5:40 video tutorial on October 26, 2018. It has been watched 93,957 times on YouTube.

Channel
Jie Jenn
Duration
5:40
Published
October 26, 2018
Views
93,957
Likes
328

Tags

Share

Further reading

  • Excel formula: Sum if multiple criteria | Exceljet exceljet.net

    Excel Formula Training. Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and…

  • How to use the SUMIF function - Easy Excel Formulas excel-easy.com

    And Criteria. Summing with And criteria in Excel is easy. 1. For example, to sum the cells that meet the following criteria: Google and Stanford (two criteria ranges), simply use the SUMIFS function (with the letter S a…

  • How to Sum Matching Values From Multiple Rows in Microsoft Excel exceltip.com

    The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any…

This tutorial in other languages