View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gmfp gmfp is offline
external usenet poster
 
Posts: 2
Default count articles of a column that the result is between an intervall

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