Thanks guys for all of your help. I haven't figured it out yet, but I'll
keep plugging away at it. It is something in the text field. I have been
able to rule the number out.

Thanks again!!
Kelley

"David Biddulph" wrote:

Are you sure that the relevant entry in column AH contains "Bus Jet OEM" and
nothing else? Are there odd spaces or other non-printing characters?
Does =LEN(AH4) or whatever the row number is, show 11?

If you are still struggling you can debug the two halves separately by using
the formulae
=('Shipped against rqd Nov08'!AH4="Bus Jet OEM")
and =('Shipped against rqd Nov08'!AP40)
and copying them down the columns checking for TRUE or FALSE
--
David Biddulph

"Kell2604" wrote in message
...
I am having trouble with a formula. Most of the time it calculates
correctly. It is a sumproduct formula which is supposed to count cells in
a
range which are greater than 0 if the cells in a different range (column)
contain a certain word. Ie. count all cells in range XX if cells in
range
YY = specific text. For some reason it does not count a few lines in the
spreadsheet. It comes back with 32 when it should show 33 etc. I have
narrowed down which rows are a problem - I'm just wondering if anyone has
any
ideas why the formula would not count a certain row. Is it a formatting
issue? What things should I check for?? What kinds of things would cause
it
to bring back an incorrect value?

Thanks very much!

Formula: =SUMPRODUCT(--('Shipped against rqd Nov08'!$AH$4:$AH$527="Bus
Jet
OEM"),--('Shipped against rqd Nov08'!AP$4:AP$5270))