About this tutorial:
Video duration: 00:04:24
Download Excel Start File:
Learn how to use SUMIFS function and Table Formula Nomenclature (Structured References) to add amounts for Invoices.
Also see these videos:
Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail
Excel Magic Trick 1252: Power Query To Create Unique List of Invoice Numbers with Balances