displaying formula result

K

kalz

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?
 
F

Frank Kabel

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

kalz

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,
 
F

Frank Kabel

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
 
K

kalz

yes, it works! thankyou!

Frank Kabel said:
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
Click to expand...
 
Top