Hi, Domenic.
Sorry for my dummies, but after few hours of thinking I realized formula
needs to be
confirmed with CTRL+SHIFT+ENTER, not just ENTER. After that in front and end
of the formula
show up two symbols { and }. After correct confirmation (CTRL+SHIFT+ENTER) I
got satisfied result.
Once again, thanks for your time and help to €˜DUMMIES.

=SUM(IF(FREQUENCY(IF($B$2:$B$100=D2,$A$2:$A$100),I F($B$2:$B$100=D2,$A$2:$
A$100)),1))

--
Message posted via http://www.officekb.com