Ron Rosenfeld Wrote:
....and a jones in m25000 would not return anything, since the w25001 is
not
included in your sum_range.
--ron

This isn't quite correct. A jones in m25000 WOULD add the value in
W25001.

In SUMIF the actual sum range used is determined by the size of the
range, e.g. if you use the formula

=SUMIF(a1:a10,"apple",b1)

b1:b10 is still used as the sum range

see Excel help for further information


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=501335