This is a spreadsheet formula - Ask in an Excel group. This one is for Word.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Paula wrote:
Would someone please decipher this formula for me in
layman's term?

=SUMPRODUCT(LEN(J3:P57)-LEN(SUBSTITUTE
(J3:P57,"Discard","")))/LEN("Discard")

Thank you