Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Formula - Count Ticks | Excel Discussion (Misc queries) | |||
count duplicats, display incremental count, restart count at changein value | Excel Programming | |||
Need a count formula | Excel Discussion (Misc queries) | |||
Trying to construct a count count formula | Excel Discussion (Misc queries) | |||
COUNT Formula?? | Excel Discussion (Misc queries) |