Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
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 ?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Formula - Count Ticks LittleAnn Excel Discussion (Misc queries) 3 May 8th 23 07:44 PM
count duplicats, display incremental count, restart count at changein value JenIT Excel Programming 2 August 24th 10 09:10 PM
Need a count formula Danni2004 Excel Discussion (Misc queries) 1 August 3rd 07 05:04 PM
Trying to construct a count count formula Chris K Excel Discussion (Misc queries) 6 May 26th 07 07:20 PM
COUNT Formula?? dannyboy213 Excel Discussion (Misc queries) 4 March 16th 06 11:47 PM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"