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