SUMIF function
 

i noticed that if you have different "range" and "sum range" (different
number of rows in the array i.e i had a "range" from E2:E284 and "sum range"
from H7:H235 ) you get a wrong result, even if the values you want to SUM are
included in both "range" and "sum range"(i.e. they are in row 100 and row 105)
Anyone knows why?

both ranges need to be equal.

Mangesh


"andreas" wrote in message
...
i noticed that if you have different "range" and "sum range" (different
number of rows in the array i.e i had a "range" from E2:E284 and "sum
range"
from H7:H235 ) you get a wrong result, even if the values you want to SUM
are
included in both "range" and "sum range"(i.e. they are in row 100 and row
105)
Anyone knows why?