SUMPRODUCT

Giganews Newsgroups
Subject: SUMPRODUCT
Posted by:  Pete (psower…@murton-view.freeserve.co.uk)
Date: Sat, 19 Jul 2008

I use the following formula to calculate if any of the Cells in
J21:J28 include categories from the PlannedDowntime named range.

SUMPRODUCT(--(COUNTIF(PlannedDowntime,$J$21:$J$28)>0),--($A$21:$A$28))

Is there anyway I can do a search from within J21:J28 as above for
part of a string. I would like to look for the word "Trial" in J21:J28
but the Cell may contain "Trial Paper Break" or "Trial Dryer Jam"

Thanks

Peter

Replies