Sorry, here is the expression: =SUMIFS(C3:C45,B3:B45,""&B2,B3:B45,"<="&B3)

"fgrose" wrote:

I'm trying the new SUMIFS() function in Excel 2007 beta2 and find that this
expression produces a #VALUE! error eventhough the function wizard evaluates
everything correctly and the step-by-step evaluation is fine until the said
final error.

Is this a bug?