software

I'm trying to use COUNTIF to count the number of times a particular text
appears in a calendar range. when i do it, I keep getting a zero value. for
instance quot;butterfly charmquot; appears 12X during the year.

The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,quot;Butterfly Charmquot;)

my chart is setup with the first column being the list of items and the
second column being i.e. How Often Item Was Used, this is where I want the
result to be. that chart is sheet 1. sheet 2 is a 2006 calendar.

what am i doing wrong with the formula? does the problem lie with the
calendar?

Try putting the formula on the calendar sheet without the sheet name

=COUNTIF(B3:H111,quot;Butterfly Charmquot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;teetrinityquot; gt; wrote in message
...
gt; I'm trying to use COUNTIF to count the number of times a particular text
gt; appears in a calendar range. when i do it, I keep getting a zero value.
for
gt; instance quot;butterfly charmquot; appears 12X during the year.
gt;
gt; The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,quot;Butterfly
Charmquot;)
gt;
gt; my chart is setup with the first column being the list of items and the
gt; second column being i.e. How Often Item Was Used, this is where I want the
gt; result to be. that chart is sheet 1. sheet 2 is a 2006 calendar.
gt;
gt; what am i doing wrong with the formula? does the problem lie with the
gt; calendar?
Yes, but I'd like the results to appear on sheet 1 not on the calendar. when
i did what you instructed it copied the formula to one of the dates on the
calendar. no results.

quot;Bob Phillipsquot; wrote:

gt; Try putting the formula on the calendar sheet without the sheet name
gt;
gt; =COUNTIF(B3:H111,quot;Butterfly Charmquot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;teetrinityquot; gt; wrote in message
gt; ...
gt; gt; I'm trying to use COUNTIF to count the number of times a particular text
gt; gt; appears in a calendar range. when i do it, I keep getting a zero value.
gt; for
gt; gt; instance quot;butterfly charmquot; appears 12X during the year.
gt; gt;
gt; gt; The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,quot;Butterfly
gt; Charmquot;)
gt; gt;
gt; gt; my chart is setup with the first column being the list of items and the
gt; gt; second column being i.e. How Often Item Was Used, this is where I want the
gt; gt; result to be. that chart is sheet 1. sheet 2 is a 2006 calendar.
gt; gt;
gt; gt; what am i doing wrong with the formula? does the problem lie with the
gt; gt; calendar?
gt;
gt;
gt;

The idea was just to try and pinpoint the problem, it is easier on the sheet
itself, it can be put back later.

Are you saying it worked when done on the sheet.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;teetrinityquot; gt; wrote in message
...
gt; Yes, but I'd like the results to appear on sheet 1 not on the calendar.
when
gt; i did what you instructed it copied the formula to one of the dates on the
gt; calendar. no results.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Try putting the formula on the calendar sheet without the sheet name
gt; gt;
gt; gt; =COUNTIF(B3:H111,quot;Butterfly Charmquot;)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;teetrinityquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I'm trying to use COUNTIF to count the number of times a particular
text
gt; gt; gt; appears in a calendar range. when i do it, I keep getting a zero
value.
gt; gt; for
gt; gt; gt; instance quot;butterfly charmquot; appears 12X during the year.
gt; gt; gt;
gt; gt; gt; The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,quot;Butterfly
gt; gt; Charmquot;)
gt; gt; gt;
gt; gt; gt; my chart is setup with the first column being the list of items and
the
gt; gt; gt; second column being i.e. How Often Item Was Used, this is where I want
the
gt; gt; gt; result to be. that chart is sheet 1. sheet 2 is a 2006 calendar.
gt; gt; gt;
gt; gt; gt; what am i doing wrong with the formula? does the problem lie with the
gt; gt; gt; calendar?
gt; gt;
gt; gt;
gt; gt;
Hi Bob,

Thanks for all your help. Last night i went to bed i was so frustrated.
today i finally figured it out. it was the calendar. since the calendar was
made in such a way that the date was included in the cell, it was not
counting the text i wanted to count. So I made another calendar with cells
for text within the date cell, then the COUNTIF formula worked fine.

Once I saw that you confirmed that you said the formula was fine, I went
from there.

Again thanks for all your help.

quot;Bob Phillipsquot; wrote:

gt; The idea was just to try and pinpoint the problem, it is easier on the sheet
gt; itself, it can be put back later.
gt;
gt; Are you saying it worked when done on the sheet.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;teetrinityquot; gt; wrote in message
gt; ...
gt; gt; Yes, but I'd like the results to appear on sheet 1 not on the calendar.
gt; when
gt; gt; i did what you instructed it copied the formula to one of the dates on the
gt; gt; calendar. no results.
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; Try putting the formula on the calendar sheet without the sheet name
gt; gt; gt;
gt; gt; gt; =COUNTIF(B3:H111,quot;Butterfly Charmquot;)
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;teetrinityquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I'm trying to use COUNTIF to count the number of times a particular
gt; text
gt; gt; gt; gt; appears in a calendar range. when i do it, I keep getting a zero
gt; value.
gt; gt; gt; for
gt; gt; gt; gt; instance quot;butterfly charmquot; appears 12X during the year.
gt; gt; gt; gt;
gt; gt; gt; gt; The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,quot;Butterfly
gt; gt; gt; Charmquot;)
gt; gt; gt; gt;
gt; gt; gt; gt; my chart is setup with the first column being the list of items and
gt; the
gt; gt; gt; gt; second column being i.e. How Often Item Was Used, this is where I want
gt; the
gt; gt; gt; gt; result to be. that chart is sheet 1. sheet 2 is a 2006 calendar.
gt; gt; gt; gt;
gt; gt; gt; gt; what am i doing wrong with the formula? does the problem lie with the
gt; gt; gt; gt; calendar?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Glad you sorted it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;teetrinityquot; gt; wrote in message
...
gt; Hi Bob,
gt;
gt; Thanks for all your help. Last night i went to bed i was so frustrated.
gt; today i finally figured it out. it was the calendar. since the calendar
was
gt; made in such a way that the date was included in the cell, it was not
gt; counting the text i wanted to count. So I made another calendar with
cells
gt; for text within the date cell, then the COUNTIF formula worked fine.
gt;
gt; Once I saw that you confirmed that you said the formula was fine, I went
gt; from there.
gt;
gt; Again thanks for all your help.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; The idea was just to try and pinpoint the problem, it is easier on the
sheet
gt; gt; itself, it can be put back later.
gt; gt;
gt; gt; Are you saying it worked when done on the sheet.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;teetrinityquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Yes, but I'd like the results to appear on sheet 1 not on the
calendar.
gt; gt; when
gt; gt; gt; i did what you instructed it copied the formula to one of the dates on
the
gt; gt; gt; calendar. no results.
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Try putting the formula on the calendar sheet without the sheet name
gt; gt; gt; gt;
gt; gt; gt; gt; =COUNTIF(B3:H111,quot;Butterfly Charmquot;)
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;teetrinityquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; I'm trying to use COUNTIF to count the number of times a
particular
gt; gt; text
gt; gt; gt; gt; gt; appears in a calendar range. when i do it, I keep getting a zero
gt; gt; value.
gt; gt; gt; gt; for
gt; gt; gt; gt; gt; instance quot;butterfly charmquot; appears 12X during the year.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; The formula is like this: =COUNTIF('2006
Calendar'!B3:H111,quot;Butterfly
gt; gt; gt; gt; Charmquot;)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; my chart is setup with the first column being the list of items
and
gt; gt; the
gt; gt; gt; gt; gt; second column being i.e. How Often Item Was Used, this is where I
want
gt; gt; the
gt; gt; gt; gt; gt; result to be. that chart is sheet 1. sheet 2 is a 2006 calendar.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; what am i doing wrong with the formula? does the problem lie with
the
gt; gt; gt; gt; gt; calendar?
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;