PC Review


Reply
Thread Tools Rate Thread

Countif not counting...

 
 
bowriter
Guest
Posts: n/a
 
      1st Oct 2010
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

 
Reply With Quote
 
 
 
 
Don Guillett Excel MVP
Guest
Posts: n/a
 
      1st Oct 2010
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
 
Reply With Quote
 
bowriter
Guest
Posts: n/a
 
      1st Oct 2010
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif not counting PatriciaT Microsoft Excel Misc 2 23rd Mar 2009 10:41 PM
COUNTIF not counting properly Christine Microsoft Excel Misc 4 23rd Oct 2008 08:21 PM
COUNTIF not counting =?Utf-8?B?d2lsbCBi?= Microsoft Excel Misc 3 14th Sep 2007 05:50 PM
COUNT, COUNTIF Counting Help Please Aladin Akyurek Microsoft Excel Worksheet Functions 1 7th Nov 2003 10:22 PM
COUNTIF Not Counting Joe Microsoft Excel Worksheet Functions 7 9th Oct 2003 09:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:01 PM.