I'm using excel 2003...

I quick question; this has happened before, but I misplaced my notes
on how to fix it...

I have a countif range in Cell J8...

=COUNTIF(J9:J1019,"request")

But when I type in the word request (lower case) in cell J17, it still
totals as zero.

Is it a cell format error? Or something more malignant.

Thank you for your help in advance,

Robert

On Oct 1, 9:54*am, bowriter <roberteke...@gmail.com> wrote:
> I'm using excel 2003...
>
> I quick question; this has happened before, but I misplaced my notes
> on how to fix it...
>
> I have a countif range in Cell J8...
>
> =COUNTIF(J9:J1019,"request")
>
> But when I type in the word request (lower case) in cell J17, it still
> totals as zero.
>
> Is it a cell format error? Or something more malignant.
>
> Thank you for your help in advance,
>
> Robert

leading or trailing spaces

That was it, thank you!

On Oct 1, 10:57*am, Don Guillett Excel MVP <dguille...@austin.rr.com>
wrote:
> On Oct 1, 9:54*am, bowriter <roberteke...@gmail.com> wrote:
>
>
>
>
> leading or trailing spaces