Math Formulas
Learn Excel mathematical formulas including SUM, SUMIF, SUMIFS, SUMPRODUCT, and more. Perform calculations, aggregations, and mathematical operations.
Functions in this Category
Common Use Cases
Conditional summing
Generate formula for this →Weighted averages
Generate formula for this →Counting with criteria
Generate formula for this →Rounding numbers
Generate formula for this →Mathematical calculations
Generate formula for this →Detailed Function Guides
SUMIF
Learn SUMIF to sum cells based on criteria. Master single-condition summing with text, numbers, dates, and wildcards....
Example:
=SUMIF(A:A, "Apple", B:B)Sum column B where column A equals 'Apple'
SUMIFS
Master SUMIFS for summing with multiple conditions. Learn to combine criteria for powerful conditional calculations....
Example:
=SUMIFS(C:C, A:A, "Sales", B:B, ">1000")Sum column C where A='Sales' AND B>1000
COUNTIF
Learn COUNTIF to count cells meeting specific criteria. Count text, numbers, dates, blanks, and use wildcards....
Example:
=COUNTIF(A:A, "Apple")Count cells containing 'Apple'
Related Formula Categories
Need a Custom Math Formula?
Describe your calculation in plain English and our AI will generate the perfect formula for you.
Try Formula Generator Free