Staff Skills academy+
Home » Courses » Microsoft Excel for Beginners Certification » Module 15 : SUMIF Formula
Module 15 : SUMIF Formula
15.1 SUMIF Formula The SUMIF function is used to add up the values in a range that meet the criteria specified. For example, if you want Excel to only add up values greater than a certain number, you can do that with the SUMIF function. The formula for the SUMIF function is as follows: SUMIF(range, criteria, [sum_range]) Range: you must input the range of cells you want to be taken into account for the function. Criteria: The criteria could be in the form of a number, text, an expre...
Lessons
- Module 1 : Introduction to Excel
- Module 2 : Add
- Module 3 : Multiply
- Module 4 : Subtraction in Excel
- Module 5 : Dividing
- Module 6 : Sort
- Module 7 : Percentage
- Module 8 : Running Totals
- Module 9 : Print
- Module 10 : Paste Special
- Module 11 : Merge
- Module 12 : Filter
- Module 13 : AVERAGE
- Module 14 : AVERAGEIF
- Module 15 : SUMIF Formula
- Module 16 : IF Formula
- Module 17 : VLOOKUP
- Module 18 : HLOOKUP
- Module 19 : COUNTIF Formula
- Module 20 : COUNTBLANK
- Module 21 : COUNTA Formula
- Module 22 : COUNT Formula
- Module 23 : CONCATENATE
- Module 24 : TRANSPOSE
- Module 25 : DATE Formula
- Module 26 : MONTH Formula
- Module 27 : Pivot Tables
- Module 28 : Pie Charts
- Module 29 : Doughnut Charts
- Module 30 : Line Charts
- Module 31 : Column Charts
- Module 32 : Bar Charts
- Module 33 : Number Formatting
- Module 34 : Create Borders
- Module 35 : Conditional Formatting
- Module 36: Comments
