=SUMPRODUCT(--(A2:A20="aaa"),--($B$2:$B$20=$C$2),--($B$2:$B$20<=$D$2))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gmfp" wrote in message
...
I need to count the diferent articles of a column where the result its
between an interval (the criteria is defined in two cells).
in my datasheet its possible that the same article has different results.

example:
Data
____________________
(articles) (result)
Column A Column B
aaa 7
bbb 7
aaa 15
aaa 6
aaa 8

criteria
____________________
Column C Column D
5 10

Analysing the result, i have 3 "aaa" and 1 "bbb".
I want to konw a formula that the result result is 2 articles (artilce
"aaa"
+ article "bbb").
thanks,
gmfp