And what is "Count of Observations"?

The way I read the formula you were looking for this text in column I
AND for "ACS-Prince George" to be in column H and you wanted to count
how often this happened.

Pete

On Jan 20, 1:38*am, jeannie v
wrote:
0 is to add all Count of Observations greater than 0....I did take the 0

out and it give me a result of "0".

Any more help you can provide would be appreciated.
--
jeannie v



"Pete_UK" wrote:
What is the

0

doing at the end of the second term?

I suggest you get rid of this.

Hope this helps.

Pete

On Jan 20, 12:33 am, jeannie v
wrote:
Hi Experts:

This is my formula: =SUMPRODUCT(--('SP TCS REPORT'!H2:H10000="ACS-Prince
George"),--('SP TCS REPORT'!I2:I10000="Count of Observations"0))

The total of records should be 182 but this formula displays 179

There is no hidden data and the naming conventions for ACS-Prince George and
Count of Observations are exactly the same through the entire document..

Can you tell me what might be wrong with this formula?

Thank you for any help you can provide,
--
jeannie v- Hide quoted text -

- Show quoted text -