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