See how to use SUMIF function in Excel to conditionally sum cells. Real-life formula examples with all kinds of criteria including dates, text, numbers, wildcards, blanks and non-blanks.