ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum for count formula please... (https://www.excelbanter.com/excel-worksheet-functions/451065-sum-count-formula-please.html)

driller3_banter

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 ?


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com