• how to use sumifs and wildcard
    Formulas

    Sumifs and wildcard condition on column contents

    The most used formula in excel is SUMIFS, which, in my opinion, together with a wildcard condition, is the element which supports and ensures the existence and usage of excel application. Let’s imagine we have a spreadsheet which contains 2…

  • Sumifs across multiple sheets
    Formulas

    SUMIFS across multiple sheets

    First you have to define a SheetList range name (the range of sheet names being the sources of SUMIFS). You can input the name of the sheets in a separate sheet of your excel file. Select all the cells containing…