Decipher Formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paula (anonymous_at_discussions.microsoft.com)
Date: 12/03/04 

Date: Fri, 3 Dec 2004 09:58:05 -0800

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

Quantcast