Decipher Formula

[Paula]

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

=SUMPRODUCT(LEN(J357)-LEN(SUBSTITUTE
(J357,"Discard","")))/LEN("Discard")

Thank you

 

[Graham Mayor]

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Paula]

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>





.