| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Sumproduct to count text occurence
I'm counting excel records (rows) using the following conditions:
=SUMPRODUCT((Ship05!$A$2:$A$428<"")*(Ship05!$B$2: $B$428DATEVALUE("03/31/05"))*(Ship05!$B$2:$B$428<=DATEVALUE("06/30/05"))*(Ship05!$M$2:$M$428="Freight Damage")) Instead of "Freight Damage" in column M, I want use a wildcard to count the records containing other "Freight" text strings. -- Dave |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Sumproduct to count text occurence
You might be able to use
ISNUMBER(search("Freight",Ship05!$M$2:$M$428)) "Dave" wrote: I'm counting excel records (rows) using the following conditions: =SUMPRODUCT((Ship05!$A$2:$A$428<"")*(Ship05!$B$2: $B$428DATEVALUE("03/31/05"))*(Ship05!$B$2:$B$428<=DATEVALUE("06/30/05"))*(Ship05!$M$2:$M$428="Freight Damage")) Instead of "Freight Damage" in column M, I want use a wildcard to count the records containing other "Freight" text strings. -- Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| parsing text in a multiple column count | Excel Worksheet Functions | |||
| URGENT: Search for text in column and count by month | Excel Discussion (Misc queries) | |||
| How do I count wildcard text meeting certain criteria in EXCEL? | Excel Worksheet Functions | |||
| sumproduct partial text count | Excel Worksheet Functions | |||
| Count by Colour (Text) with other criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
