Excel 2007 SUMIFS Function
Monday May 11, 2009
A recent post in this site's forum ask a question about combining the AND function with the SUMIF function in order to add up data that met specific criteria in two other data ranges .
Rather than do this, a simpler way would be to use the SUMIFS function which is similar to SUMIF except that SUMIFS allows you to specify from 2 to 127 criteria ranges rather than just one.
For example, the function can be used to pick out data from specific years. This would allow you to add up only the profits for say 2006 and 2007 from a worksheet containing data from 2004 to 2009.
To find out the details, read the article on using the Excel 2007 SUMIFS Function.
Related Articles
Rather than do this, a simpler way would be to use the SUMIFS function which is similar to SUMIF except that SUMIFS allows you to specify from 2 to 127 criteria ranges rather than just one.
For example, the function can be used to pick out data from specific years. This would allow you to add up only the profits for say 2006 and 2007 from a worksheet containing data from 2004 to 2009.
To find out the details, read the article on using the Excel 2007 SUMIFS Function.
Related Articles
No comments yet. Leave a Comment