WildWill;280891 Wrote:
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!

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=78442