Hi
have you entered the formula with CTRL+SHIFT+ENTER as array formula.
Also you may use the following instead
=COUNTIF($O$6:$O$10,"=" & O10)
--
Regards
Frank Kabel
Frankfurt, Germany
"MMV" schrieb im Newsbeitrag
...
The formula : =SUM(IF($O$6:$O$10=O10,1,0)) in the formula window
diplays the
correct answer of 2.000. The range does have 2 numbers that are
greater or
equal to 010. The cell were the formula resides displays 1.000.
Unable to
figure out why. Formula does work in previous year worksheet.
|