A
andreas
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?
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?