Sorry, I thought I was in the Excel message board
-----Original Message-----
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
.