- The IF function introduces decision making which adds flexibility to your to spreadsheets.
- The SUM function makes it easy to add up data located in rows or columns.
So useful are these two functions, that they have been combined into one - The SUMIF function.
SUMIF will add up values if a certain criterion is met. You get to specify the criterion to be used and also the data to be summed.
To find out more, read this step by step tutorial on the Excel SUMIF Function.Related Step by Step Tutorials