Find text containing "XXX" in SUMPRODUCT

[WildWill]

I am using a SUMPRODUCT statement to calculate data in a spreadsheet. I want
one of the elements of this SUMPRODUCT to look into a range of cells (A1:
A20) and find all occurences where the text in (A1: A20) contains the text
string "XXX". Thanks!

 

[Pecoflyer]

I am using a SUMPRODUCT statement to calculate data in a spreadsheet.
want
one of the elements of this SUMPRODUCT to look into a range of cell
(A1:
A20) and find all occurences where the text in (A1: A20) contains th
text
string "XXX". Thanks!

in your SUMPRODUCT introduce isnumber(find("xxx",a1:a20))
FIND is case-sensitive, you can also use SEARC

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste