Sumif question
On Sat, 14 Jan 2006 18:21:22 -0600, daddylonglegs
wrote:
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
Interesting. I didn't realize that.
In any event, the OP's problem possibly still stems from the sum range being
offset by 1.
--ron
|