Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If field calculation | Microsoft Word Help | |||
field formula | Tables | |||
I need a formula of amount of hours from two times in two cell? | Tables | |||
Formula in table - Creating a final total from sub-total cells | Tables |