On Sat, 14 Jan 2006 07:59:34 -0500, "J Shrimps, Jr."
wrote:

Using a sumif formula to lookup
values in three colums.
Formula wuz "SUMIF(w2:w25000,"jones",m3:m25000)"

This formula produced results off by a factor of ten or twenty.
The formula should have read "m2:m25000"
I didn't think having one row "m1/m2" in the SUMIF
formula would make such a difference.
The variable "jones" didn't have any values in
the top 2000 rows, much less the first two.





You might check to be sure that you are matching the correct rows.

For example, in your function, a "jones" in w3000 would match the value in
m3001; and a jones in m25000 would not return anything, since the w25001 is not
included in your sum_range.


--ron