It seems that I have to concatenate the criteria arguments in the
SUMIF and SUMIFS functions since I have moved to Excel 2007. For
example, "D$4" must become ""&D$4 in the Excel 2007 version. Is this
a change in syntax or a bug that needs to be addressed. Any
thoughts...


Jim