View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kell2604 Kell2604 is offline
external usenet poster
 
Posts: 39
Default 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