| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count rows if 2 columns partially match
Hi,
Am Thu, 25 Oct 2012 15:35:01 +0000 schrieb Qikstart: 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 for task and closed try: =SUMPRODUCT(--(LEFT(A72:A77,4)=A81),--(B72:B77="closed")) or with excel version 2007 or 2010: =COUNTIFS(A72:A77,A81&"*",B72:B77,"closed") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if two columns match different criteria | Excel Worksheet Functions | |||
| Userform combobox: best match on partially typed content? | Excel Programming | |||
| match week, count rows, sum rows? | Excel Worksheet Functions | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
| If two columns match then count one. How? Tried countif and sum . | Excel Worksheet Functions | |||
Threaded Mode
