1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel SUMIFS Function

By

Excel's SUMIFS function is similar to the SUMIF function except that it is used to add up data only if specific criteria are met in two or more ranges of cells.

The function can be used to pick out data for specific years - allowing you, for example, to add up only the profits for the year 2006 and 2007 from a worksheet containing data from 2004 to 2008.

To find out the details, read the step by step tutorial on using the Excel SUMIFS Function.

Related Step by Step Tutorials

©2014 About.com. All rights reserved.