Excel - Sum All VLOOKUP Matching Rows #shorts - Episode S0055

Microsoft Excel Tutorial: VLOOKUP in Excel and Sum All Matching Values

One of the most common questions is how can I do a VLOOKUP in Excel and sum all of the matches? You can't do it with VLOOKUP because VLOOKUP only finds the first match. It won't work with XLOOKUP either, because you can only find the last match. Instead, you can use SUMIF or SUMIFS to get the total of all VLOOKUP matches.

Welcome to another #shorts video from MrExcel! In this quick tutorial, we're going to tackle a common issue with VLOOKUP - how to sum all matching rows. I know this can be frustrating, but don't worry, I've got you covered.

As you may already know, VLOOKUP can only return the first match it finds. But what if you need to sum up all the matching rows? Well, that's where things get a little tricky. XLOOKUP does have a solution with the -1 trick, but not everyone has access to it. So, we have to get creative with the tools we have at hand.

In this video, I'll show you how to use a combination of VLOOKUP, XLOOKUP, INDEX, and MATCH to achieve the desired result. But the real hero here is SUMIFS. By using this function, we can easily sum up all the matching rows without any hassle. Just specify the range to sum, the range to search, and the criteria to look for - in this case, cherry, apple, and banana.

And there you have it - the total values for cherry. If you select all the cells and look at the status bar, you'll see the sum of all the matching rows - 3,513. I know many of you have been searching for a way to combine VLOOKUP and SUM, but trust me, SUMIFS is the way to go. It's simple, efficient, and gets the job done.

If you found this video helpful, please consider visiting TL.Page/MrExcel for more tutorials and resources. You'll also find my group lessons and plenty of other videos to help you become an Excel pro. Thanks for watching, and don't forget to like, comment, and subscribe for more #shorts videos from MrExcel!

Table of Contents
(0:00) Problem Statement: Excel VLOOKUP All Matches
(0:10) VLOOKUP can only find 1st match. XLOOKUP can find last match.
(0:20) Solve using SUMIFS function in Excel
(0:38) Checking answer in Excel Status Bar
(0:49) Wrap-Up

This video answers these search terms:
How To Do A VLOOKUP Sum In Excel
How To Lookup And Sum In Excel
How To Sum A Column Using VLOOKUP In Excel
How To Sum A XLOOKUP In Excel
How To Sum In Excel Using VLOOKUP
How To Sum In Excel Using VLOOKUP Column
How To Sum In Excell Using VLOOKUP
How To Use Lookup And Sum In Excel
How To Use VLOOKUP And Sum In Excel
How To Use VLOOKUP With Sum In Excel?
How To VLOOKUP And Sum In Excel

[kristinabjelic]

I've been trying to figure this out for like ONE HOUR with different tutorials until I saw this! THANK YOU SO MUCH!

[kylebroaddrick]

Exactly what I needed to know! Thank you.

[davisrailey]

You’ve earned another sub. Thank you for helping me with my job

[mikachan]

Been scratching my head for hours, trying many logics, but apparently sumifs do the trick, thankyou so much

[BIODevacy]

Thank you so much for sharing your experience <3

[LeanneOConnell-ws]

OMG have been trying to figure this out, like everyone else using vlookups and sum with no luck, for hours! Thank you this was so easy!

[SVU-Debut]

I've been working on this for about an hour and have over 3k values to sum. I thought it was too simple of a solution, but it worked!

[gdmrbxl]

I got stuck using bc i was using SUMIF not SUMIFS but figured it out with SUMIF you!

[gairiksaha]

Been trying to do this for more than 2 hours. Tried so many different things. And yes, you are right. Looked for vlookups with sum, sum with vlookups.

Thanks a bunch for the solution. This was so easy.

[AshleyBrookman-mu]

I keep getting #spill. I can't figure it out.

[unbeliverpool]

Towards the end, how did you generate all three sums by only hitting enter? without copying and paste each formula.

[waltmorris]

Thanks for this video! How would you add a date range component to the formula? Say there is a column of data for "Month" and you only want to return Amounts for "August" or whichever month in question?

[MohamedSaBieh-mt]

Thanks 🎉 ❤❤❤❤❤❤❤❤❤❤❤❤ its really good

[jashkoradia]

Not working
Its showing me J# in last item i.e in criteria

[sjpdefault]

what if the details are from another worksheet? can you do a video tutorial pls

[drhenry]

How can I do this if what I am looking for is only a partial match to the column I'm looking in?

[Koolkole]

How to do it if the values your adding up and where your looking are in a table that gets longer.

[stanleygeeks]

in your study case the data is just on single row, what if more than one row we need to sum? i still meet trouble with this please help

[krunalmistry]

Wow
I am finding the same solution with v lookup formula
But answer exist in sumifs formula