Excel Magic Trick 1251: SUMIFS & Table Formula Nomenclature (Structured References) to Add Invoices

About this tutorial:

Video duration: 00:04:24
Download Excel Start File:

Download 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

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

9 thoughts on “Excel Magic Trick 1251: SUMIFS & Table Formula Nomenclature (Structured References) to Add Invoices

    Jim E

    (June 28, 2020 - 1:57 pm)

    Need someone who will work for an hourly rate on some excel sheets for a research project. Im OK at the simple stuff, but this is out of my league. Where do i find free lancers for such work?

    Ghazwan Elias

    (June 28, 2020 - 1:57 pm)

    I have a Question
    how can I change the default font ( Arial ) to ( Calibri ) in Excel 2013 ?
    Thank you Mike

    James Lee

    (June 28, 2020 - 1:57 pm)


    Gud Day Sir MIke, i don't know if this is the right place to request…

    I would like to request for a tutorial for searchable dropdown list.
    searchable dropdown list – when you type a certain letter or word excel automatically
    suggest data from the data validation list created
    and displays it for the data encoder then the encoder will just press
    down2x until he gets to the desired data…. (just like google search).

    i know this is crazy or impossible but i know with you
    nothing is impossible…

    Thank you so much for your time and effort.. I really appreciate it.

    Alan Douglas

    (June 28, 2020 - 1:57 pm)

    Another awesome video, thanks Mike


    (June 28, 2020 - 1:57 pm)

    Thanks Mike.


    (June 28, 2020 - 1:57 pm)

    Nice refresher on the Table references dynamics, Excel it is so rich of features that sometimes we simply forget them :S

    Excel On Fire

    (June 28, 2020 - 1:57 pm)

    nice focus on just the nomenclature.

    Kevin Lehrbass

    (June 28, 2020 - 1:57 pm)

    I'm looking forward to your Power Query video Mike!

    Level Zero

    (June 28, 2020 - 1:57 pm)

    Hey uncle Michael! Where are u today??

Leave a Reply

Your email address will not be published. Required fields are marked *