Skip to playerSkip to main contentSkip to footer
Bill Jelen
  • 5/3/2011
The question: "Why won't VLOOKUP add up all the matching results?" Today, Episode #1396 will show us how to use the SUMIF function instead of VLOOKUP. Included in today's episode... "Why it is important to lock the rows in your VLOOKUP table range."

Recommended

2:34
Up next
MrExcel's Learn Excel #976 - Default Comment
Bill Jelen
2/25/2015
3:19
Learn Excel 2010 - "Date Next to a Yes" #1474
Bill Jelen
12/28/2011
7:51
Dueling Excel - "Rank Ties by Weight" #1473
Bill Jelen
12/28/2011
3:39
Learn Excel 2010 – “Wrap Cells and Resize" #1472
Bill Jelen
12/28/2011
2:08
Learn Excel 2010 - "Random with No Repeats" #1471
Bill Jelen
12/28/2011
6:30
Learn Excel - "Copy Total to Weeks Macro": #1470
Bill Jelen
11/29/2011
2:22
Learn Excel - "Random Weeks Over 6 Months": #1469
Bill Jelen
11/29/2011
2:58
Learn Excel - "Added Times Won't Calculate": #1468
Bill Jelen
11/29/2011
1:01
Learn Excel - "Column B is now Column 2?": #1467
Bill Jelen
11/21/2011
1:26
Learn Excel 2010 - "Embed a PDF in Excel": #1466
Bill Jelen
11/14/2011
2:24
Learn Excel 2010 - "Remove Spaces with VBA": #1465
Bill Jelen
11/10/2011
5:49
Dueling Excel - "Keep The Last Duplicate": #1464
Bill Jelen
11/7/2011
2:02
Learn Excel - "Left 26, Even If Only 10": #1463
Bill Jelen
11/7/2011
1:50
Learn Excel 2010 – “Word Count from Word”: #1462
Bill Jelen
11/3/2011
6:24
Learn Excel "Pivot Table Defaults": Podcast #1461
Bill Jelen
11/2/2011
4:00
Learn Excel - "Word Count from Sentences": #1460
Bill Jelen
11/2/2011
9:09
Dueling Excel- "Pivot Table Totals on Left": #1459
Bill Jelen
11/2/2011
2:29
Learn Excel - "Scroll In The Formula Bar": #1458
Bill Jelen
11/2/2011
3:17
Learn Excel 2010 - "Excel Outside The Box": #1457
Bill Jelen
11/2/2011
2:58
Learn Excel from MrExcel - "Pivot to Range": #1456
Bill Jelen
11/2/2011
1:37
Learn Excel 2010 - "Drag Formula Reference": #1455
Bill Jelen
10/31/2011
7:54
Dueling Excel - "The Top 70%": Podcast #1454
Bill Jelen
10/26/2011
5:13
Learn Excel 2010 - "Clear If New Day": #1453
Bill Jelen
10/24/2011
4:16
Learn Excel 2010 - "Shift Change?": Podcast #1452
Bill Jelen
10/24/2011
3:21
Learn Excel 2011- “MAC xlautomatic”: Podcast #1451
Bill Jelen
10/19/2011