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

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

Hi Kell;
This is what it reads:

1- IF the concatenation of A12 - C1 - 0, does exist in the range BD4:BD2000
located at sheet "CURRENT MPS", brings value found.
2- IF the concatenation of A12 - C1 - 1, does exist in the range BD4:BD2000
located at sheet "CURRENT MPS", brings value found.
3- Add 1 and 2

Let me know if you understand. Like the Roman emperator said, the secret is
to devide and you will rule.

Argy


"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

Perhaps I should clarify something. Since the formula used is Count if, when
I said bring value found means that all the values that have met the
criteria, will be counted and added in each individual piece or what I called
1 and 2. Then, they will be added together.

Argy


"Argy - Arcasoft" wrote:

Hi Kell;
This is what it reads:

1- IF the concatenation of A12 - C1 - 0, does exist in the range BD4:BD2000
located at sheet "CURRENT MPS", brings value found.
2- IF the concatenation of A12 - C1 - 1, does exist in the range BD4:BD2000
located at sheet "CURRENT MPS", brings value found.
3- Add 1 and 2

Let me know if you understand. Like the Roman emperator said, the secret is
to devide and you will rule.

Argy


"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

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

Thanks for the help as always!! Makes sense.

"Argy - Arcasoft" wrote:

Perhaps I should clarify something. Since the formula used is Count if, when
I said bring value found means that all the values that have met the
criteria, will be counted and added in each individual piece or what I called
1 and 2. Then, they will be added together.

Argy


"Argy - Arcasoft" wrote:

Hi Kell;
This is what it reads:

1- IF the concatenation of A12 - C1 - 0, does exist in the range BD4:BD2000
located at sheet "CURRENT MPS", brings value found.
2- IF the concatenation of A12 - C1 - 1, does exist in the range BD4:BD2000
located at sheet "CURRENT MPS", brings value found.
3- Add 1 and 2

Let me know if you understand. Like the Roman emperator said, the secret is
to devide and you will rule.

Argy


"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