Thank you all...you got me thinking and...I figured out what I was doing
wrong....this is the correct formula to get the correct result.

=SUMPRODUCT(--('SP TCS REPORT'!H2:H10000="ACS-Prince George"),--('SP TCS
REPORT'!I2:I10000))
--
jeannie v


"Ron Rosenfeld" wrote:

On Sat, 19 Jan 2008 16:33:01 -0800, 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,

After reading some of your other responses, I wonder if what you really want
is:

=sumif('SP TCS REPORT'!H2:H10000,"ACS-Prince George",'SP TCS REPORT'!I2:I10000)


--ron