ExcelBanter - Using Sumproduct to count text occurence

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using Sumproduct to count text occurence (https://www.excelbanter.com/excel-worksheet-functions/101234-using-sumproduct-count-text-occurence.html)

Dave

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

Barb Reinhardt

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

All times are GMT +1. The time now is 10:27 PM.