AI-Powered Excel Assistant
=SUMIF(range, criteria, [sum_range])=SUMIF(A:A, "Apple", B:B) - Sum column B where A equals "Apple"=SUMIF(B:B, ">100") - Sum values greater than 100=SUMIF(A:A, "*phone*", B:B) - Sum with wildcard matching=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)=SUMIFS(C:C, A:A, "Sales", B:B, ">1000")=SUMIFS(D:D, A:A, "East", B:B, "Q1")| Type | Example |
|---|---|
| Exact text | "Apple" |
| Numbers | 100 |
| Comparisons | ">100", "<50" |
| Wildcards | "*", "?" |
| Cell references | A1 |
These functions are essential for data analysis and creating dynamic reports.
Master the TEXT function to format numbers, dates, and times exactly how you want them displayed in Excel.
Learn to use Excel IF function for logical tests, create nested IF statements, and use modern alternatives like IFS and SWITCH.
Master conditional summing in Excel with SUMIF for single criteria and SUMIFS for multiple criteria calculations.