Since the OP's range was
SUMIF(w2:w25000,"jones",m3:m25000)
then if there is a jones in W25000 it would return the value from
M25001 which if it is empty will return a zero. Don't know where jones in
the m
column came from since that is column the OP wants to sum?
--
Regards,
Peo Sjoblom
Portland, Oregon
"daddylonglegs"
wrote in message
news:daddylonglegs.21ngvm_1137284702.0856@excelfor um-nospam.com...
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