Excel 2007 SUMIFS Function
Wednesday January 14, 2009
Excel 2007'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.
For example, 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 article on using the Excel 2007 SUMIFS Function.
Related Articles
For example, 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 article on using the Excel 2007 SUMIFS Function.
Related Articles
One difficulty I have in making this function work is substituding a range name that has a numerical value, say a range name “monthofsale” being 36 for the first criteria and summing to the “monthofsale”+12 being the second criteria. If I put in 36 and 48 the sumifs function works. If I put in the range name I get a value of 0. Any suggestions? I would like to use this function to sum the monthly net operating income for each month from the month of sale.
I ran across the same problem as you Jack.
I found a work around by “building” the string I wanted using the CONCATENATE function.
So you could do something like: SUMIFS(RANGE1, RANGE2, CONCATENATE(”=”, B$25) )
See this builds the criterion string, which would allow you to enter something complicated from your spreadsheet.