Not able to use SUMIFS in Microsoft Excel

[ProBaal]

Where cells M12 and M15 contain the number 39315 and 39317, respectively. The formula yields no results when M12 and M15 are in the formula. However, when I substitute the actual number in the formula, the proper result is produced.

=SUMIFS(G2:K2,$G$1:$K$1,">=M12",$G$1:$K$1,"<=M15") does not work
=SUMIFS(G2:K2,$G$1:$K$1,">=39315",$G$1:$K$1,"<=393 17") works

[Mulan]

I think this might will work =SUMIFS(G2:K2,$G$1:$K$1,">=" &M12,$G$1:$K$1,"<=" &M15). It is necessary to re-modify the content of formula and then check back.

[Kohlmann]

Append the cell reference with the ampersand otherwise excel sees it as a text value and looks for the text string ">=M12" will look for the string "M12" not the contents ">="&M12 will look for the contents of cell M12.

[Bachelot]

This function is to increase the sum if function. This is summed only if all criteria are met. The syntax of this function deviates significantly from the sum if-syntax. This feature was introduced with MS Excel 2007. Formula: = SUMIF. The controller is all the transactions made ??by customer A and greater than 25.000, - € are summed, in order for this later to perform a customer analysis.

SUMIFS function - http://office.microsoft.com/en-us/ex...010047504.aspx

[Sarasi]

Excel 2007 incorporates the function = SUMIFS that allows a Conditional Sum based on various criteria. Function is similar to SUMAR.SI, but in the case of the new function can be used up to 127 new approaches simultaneously. = SUMIFS (sum_range; rango_criterios1; criteria1, [rango_criterios2; criteria2], ...)