View Single Post
  #1   Report Post  
driller3_banter driller3_banter is offline
Junior Member
 
Posts: 6
Default sum for count formula please...

I have 1 sheet with 2 columns of data
I like to have 1 formula that fill-in counting parameter.

C1=entry of min value to filter B3:B22
D1=entry of max value to filter B3:B22

A3:A22 contains pure text without blanks
B3:B22 contains pure numbers (-/0/+)

I need only to count how many unique text are present on Col A which are aligned within the filter values at Col B.

I tried this formula but please advise.
{=SUM(IF(AND(B3:B22=C1,B3:B22<=D1,FREQUENCY(MATCH (A3:A22,A3:A22,0),MATCH(A3:A22,A3:A22,0))0),1))}

Did I missed something ?