LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default how to count rows if 2 columns partially match

I am trying to count rows based on following pseudo-code:
if (cellA&"*" matches colARange) AND "text" matches colBRange)
count

columns:
taska new
taskb closed
taskc closed
problema closed
problemb new
problemc closed

task
problem

The verbalized summary is that I want to search for rows which match "text*" AND "closed" or "new". Expected counts would be:
"text*" with "new": 1
"text*" with "closed": 2
"problem*" with "closed": 2
etc
I've tried multiple formulas, but I can't piece it all together to actually work:
=SUMPRODUCT((A$72:A$76=A81&"*")*(B$72:B$76="closed "))
=COUNT(IF((A72:A76=A81&"*")*(B72:B76="closed"),))
=ISNUMBER(SEARCH(A81,A72:A77))

Can someone help me put the pieces together correctly?

TIA
 
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 if two columns match different criteria Curt D. Excel Worksheet Functions 5 May 14th 23 07:44 PM
Userform combobox: best match on partially typed content? ker_01 Excel Programming 4 March 27th 09 02:56 PM
match week, count rows, sum rows? earls Excel Worksheet Functions 2 January 5th 07 02:34 AM
Need rows in Column A removed if they fully or partially match with any Column B row [email protected] Excel Discussion (Misc queries) 1 August 21st 05 11:41 PM
If two columns match then count one. How? Tried countif and sum . IMC Medrec Excel Worksheet Functions 1 February 14th 05 12:28 PM


All times are GMT +1. The time now is 04:42 PM.

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

About Us

"It's about Microsoft Excel"