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 ?
|