Very good.

The next thing to look for is text problems:

"Bus Jet OEM "
instead of:
"Bus Jet OEM"


--
Gary''s Student - gsnu200817


"Kell2604" wrote:

Can you explain how that would be? I have sperated out 2 rows. One which
the formula counts and the other it does not. They both have the number 2.2
in the cell to be counted. If I check the formatting they are both formatted
as a number with one decimal. If I do a customer filter for all rows with a
cell value greater than 0 they both come up.

"Gary''s Student" wrote:

It is probably a value that LOOKS like it is greater than zero, but is
actually not.
--
Gary''s Student - gsnu200817


"Kell2604" wrote:

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))