displaying formula result

[Guest]

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?

 

[Guest]

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

 

[Guest]

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,

 

[Guest]

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

 

[Guest]

yes, it works! thankyou!

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