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?