1. Computing
Ted French

Excel SUMIF Function

By January 19, 2012

Follow me on:

Two of the most useful functions available in Excel are the IF Function and the SUM Function:

  • 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
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.