View Single Post
  #1   Report Post  
Paula
 
Posts: n/a
Default Decipher Formula

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