Dear users,
I have a little problem that disturbes me all day now,
I want to use the countif function for a certain array. The range is set by another cell which is made up out of a percentile of an entire row.
The problem is is that excel doesn't see the value it displays so i continuously get a value of 0 in the countif cell. If i fill in the range by hand, which is exactly the same range as the outcome of the percintile the countiff cell does give the correct value.
So in short the problem is i guess that the countiff cell does not recognize the value because this value is made up by a formula.
Is there anyway around this?
Thank you in advance
Bookmarks