| 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 | |||
Linear Mode
