Help Reading Formula - Again!
Thanks Again - Got it!!
"Sheeloo" wrote:
It will count the number of times $A12-C$1-0 and $A12-C$1-1 occur in the
range $BD$4:$BD$2000 on the 'Current MPS' sheet.
$A12-C$1-0 means value in A12 then a dash then value in C1 then another dash
and a zero...
To see what it means enter this in any cell
=CONCATENATE($A12,"-",C$1,"-0"))
"Kell2604" wrote:
Hi Everyone -
You were a big help a week or two ago, walking me through how to decipher a
complicated formula. I have another one for you!
=COUNTIF('CURRENT
MPS'!$BD$4:$BD$2000,CONCATENATE($A12,"-",C$1,"-0"))+COUNTIF('CURRENT
MPS'!$BD$4:$BD$2000,CONCATENATE($A12,"-",C$1,"-1"))
Thanks in advance...
Kelley
|