All
Search
Images
Videos
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
exceljet.net
Sum matching columns and rows
To sum values in matching columns and rows, you can use the SUMPRODUCT function. In the example shown, the formula in J6 is: =SUMPRODUCT((codes=J4)*(days=J5)*data) where data (C5:G14), days (B5:B14), and codes (C4:G4) are named ranges. Note: In the latest version of Excel you can also use the FILTER function, as explained below.
Oct 26, 2022
Shorts
11:48
246.8K views
VLOOKUP | Sum ALL Matching Values Or Sum ENTIRE MATCHING ROW
Chester Tugwell
0:55
227.5K views
VLOOKUP + SUM: How to use Excel VLOOKUP and SUM all the matches results
Learn Excel to excel
Vlookup Tutorial
21:50
Excel Vlookup Tutorial - Everything You Need To Know
YouTube
Excel Campus - Jon
2.7M views
Aug 15, 2019
2:58
How to use the VLOOKUP function in Excel
YouTube
TechOnTheNet
4.9M views
Sep 28, 2018
1:01
How to use VLOOKUP in Excel
YouTube
Microsoft 365
3.7M views
Nov 25, 2019
Top videos
Sum matching columns
exceljet.net
Nov 1, 2022
5:56
Sum a Column Based on Values in Another - Excel University
excel-university.com
May 22, 2019
VLOOKUP Return Multiple Matching Rows and Columns - Excel University
excel-university.com
Nov 13, 2019
Vlookup Examples
5:43
VLOOKUP in Excel | Step-by-Step Tutorial for Beginners
YouTube
Kevin Stratvert
1.2M views
11 months ago
2:38
How to use VLOOKUP in Microsoft Excel
YouTube
Microsoft 365
2.6M views
Apr 27, 2021
32:09
VLOOKUP in Excel | Tutorial for Beginners
YouTube
Kevin Stratvert
2.3M views
Mar 10, 2021
Sum matching columns
Nov 1, 2022
exceljet.net
5:56
Sum a Column Based on Values in Another - Excel University
May 22, 2019
excel-university.com
VLOOKUP Return Multiple Matching Rows and Columns - Excel Univer
…
Nov 13, 2019
excel-university.com
Lookup and sum column
Oct 26, 2022
exceljet.net
SUM With a VLOOKUP Function – Excel & Google Sheets
Feb 22, 2023
automateexcel.com
Sum & Sum If with VLOOKUP-Excel & Google Sheets
Feb 8, 2023
automateexcel.com
Index and match on multiple columns
Oct 26, 2022
exceljet.net
VLOOKUP on Two or More Criteria Columns - Excel University
Jan 10, 2014
excel-university.com
XLOOKUP two-way exact match
Nov 1, 2022
exceljet.net
VLOOKUP with 2 lookup tables
Nov 1, 2022
exceljet.net
6:17
Excel VLOOKUP function tutorial with formula examples
86.3K views
Aug 23, 2023
ablebits.com
Vlookup And Sum Matches In Rows Or Columns With Kutools For Excel
502 views
Dec 27, 2022
YouTube
Excel Time
6:30
VLOOKUP & HLOOKUP in Excel Tutorial
703.2K views
May 21, 2018
YouTube
Kevin Stratvert
2:38
How to use VLOOKUP in Microsoft Excel
2.6M views
Apr 27, 2021
YouTube
Microsoft 365
3:45
EXCEL VLOOKUP: How to LOOKUP DATA from Another SHEET!
744.3K views
Jan 2, 2020
YouTube
Online Training for Everyone
12:05
Vlookup on Date Range Lookup Value
93.7K views
Mar 9, 2021
YouTube
The Excel Cave
2:58
How to use the VLOOKUP function in Excel
4.9M views
Sep 28, 2018
YouTube
TechOnTheNet
7:40
VLOOKUP Return Multiple Matching Rows and Columns
187K views
Nov 13, 2019
YouTube
Excel University
15:20
How to Use VLOOKUP to Compare Two Lists
1.1M views
Apr 28, 2021
YouTube
Simon Sez IT
7:08
VLookup on Multiple Sheets in Excel
295.3K views
Dec 16, 2019
YouTube
Syed Shah Zahurullah Hussaini
8:30
Excel: Combining Vlookup and Match Functions
104.7K views
Feb 28, 2016
YouTube
Mike Thomas
2:43
How to use Vlookup with Sum in Excel
57.5K views
Sep 25, 2018
YouTube
Excel My Life
14:45
HOW TO: compare two columns in Excel using VLOOKUP
133.8K views
Sep 19, 2019
YouTube
Excel at Work
2:30
How To Find Same Values in Different Sheets in Microsoft Excel
86K views
Apr 29, 2020
YouTube
QuikDIY
6:16
How to Do a VLOOKUP in Excel - in 6 Minutes
7.7M views
Jul 20, 2012
YouTube
VitaminCM
6:27
How to compare two tables in excel using VLOOKUP
87.4K views
Jul 20, 2018
YouTube
Karina Adcock
12:59
Using VLookups to Match Two Data Sets in Excel
80.1K views
Nov 27, 2014
YouTube
TonicaInsight
13:34
How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)
3.8M views
Nov 28, 2019
YouTube
Leila Gharani
7:15
vlookup with sum function in excel
37.8K views
Dec 27, 2018
YouTube
Technical Computer Classes
See more videos
More like this
Feedback