SUMIF is considered one of the important Excel functions to learn. This tutorial explains how to use the SUMIF function in Excel , and it’s intended to be a comprehensive guide with many real-life SUMIF formula examples. The SUMIF Excel function is categorized under Math and Trigonometry functions. It will sum up cells that meet the given criteria. The criteria are based on dates, Learn how to use SUMIF function in Excel to sum values based on a certain condition. See real-life formula examples with text, numbers, dates, wildcards, blanks and non-blanks. Learn how to use the SUMIF function to sum by cell color in Excel with GET.CELL, VBA code, and FILTER & SUBTOTAL alternatives.