SumIf Function

[tomlinsn]

When I use named ranges for the Range, Criteria and Sum_Range, I get different values than when I use the specific cell references for the worksheet.

I have checked multiple times the defined ranges for each parameter and they appear to be correct, but I do not understand why I do not get the same results.

Any throughts would be greatly appreciated.

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=568990

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).