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