Hi,
I ve a problem tt the formula result displayed in the cell is wrong.
however, in the formula argument window, its provides correctly. anyone knows
wat happens?

Hi
- post your exact formula
- post the current result
- post the result expected
- post the values in the referenced cells

"kalz" wrote:

Hi,
I ve a problem tt the formula result displayed in the cell is wrong.
however, in the formula argument window, its provides correctly. anyone knows
wat happens?

Hi,
e.g. I'm to count the no. of products < expected = 3!, this is the
extracted data column (Sheet 1):

product
1
2
1
3
1

in Sheet 2 :
this's the formula to achieve the result-
=SUM(IF(LEN(Sheet1!A2:A100)0,1/COUNTIF(Sheet1!A2:A100,Sheet1!A2:A100)))

the displayed result in the cell is - 0.333...
but, the result in the formula argument window shows formula result =3.

do u know how this happen?

thx lox,




"Frank Kabel" wrote:

Hi
- post your exact formula
- post the current result
- post the result expected
- post the values in the referenced cells

"kalz" wrote:

Hi,
I ve a problem tt the formula result displayed in the cell is wrong.
however, in the formula argument window, its provides correctly. anyone knows
wat happens?

Hi
not really sure why you compare the length of the string? But one thing to
check first: Have you entered this formula as array formula with
CTRL+sHIFT+ENTER

"kalz" wrote:

Hi,
e.g. I'm to count the no. of products < expected = 3!, this is the
extracted data column (Sheet 1):

product
1
2
1
3
1

in Sheet 2 :
this's the formula to achieve the result-
=SUM(IF(LEN(Sheet1!A2:A100)0,1/COUNTIF(Sheet1!A2:A100,Sheet1!A2:A100)))

the displayed result in the cell is - 0.333...
but, the result in the formula argument window shows formula result =3.

do u know how this happen?

thx lox,




"Frank Kabel" wrote:

Hi
- post your exact formula
- post the current result
- post the result expected
- post the values in the referenced cells

"kalz" wrote:

Hi,
I ve a problem tt the formula result displayed in the cell is wrong.
however, in the formula argument window, its provides correctly. anyone knows
wat happens?

yes, it works! thankyou!

"Frank Kabel" wrote:

Hi
not really sure why you compare the length of the string? But one thing to
check first: Have you entered this formula as array formula with
CTRL+sHIFT+ENTER

"kalz" wrote:

Hi,
e.g. I'm to count the no. of products < expected = 3!, this is the
extracted data column (Sheet 1):

product
1
2
1
3
1

in Sheet 2 :
this's the formula to achieve the result-
=SUM(IF(LEN(Sheet1!A2:A100)0,1/COUNTIF(Sheet1!A2:A100,Sheet1!A2:A100)))

the displayed result in the cell is - 0.333...
but, the result in the formula argument window shows formula result =3.

do u know how this happen?

thx lox,




"Frank Kabel" wrote:

Hi
- post your exact formula
- post the current result
- post the result expected
- post the values in the referenced cells

"kalz" wrote:

Hi,
I ve a problem tt the formula result displayed in the cell is wrong.
however, in the formula argument window, its provides correctly. anyone knows
wat happens?