Thanks Frank,
I am not sure what you mean by CTRL+SHIFT+ENTER, but the COUNTIF formula
solved the problem. I normally find my answers via other person's questions,
which are usually answered by you. I joked with a co-worker after I posted
that "Frank Zabel from Germany" will know the answer, I was right. Although
your last name is Kabel, you are like Erik Zabel (German cyclist), usually in
first.
Thanks again.

"Frank Kabel" wrote:

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.