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 "butterfly charm" appears 12X during the year.

The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,"Butterfly Charm")

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,"Butterfly Charm")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"teetrinity" wrote in message
...
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 "butterfly charm" appears 12X during the year.

The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,"Butterfly
Charm")

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?

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.

"Bob Phillips" wrote:

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

=COUNTIF(B3:H111,"Butterfly Charm")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"teetrinity" wrote in message
...
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 "butterfly charm" appears 12X during the year.

The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,"Butterfly
Charm")

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?

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)

"teetrinity" wrote in message
...
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.

"Bob Phillips" wrote:

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

=COUNTIF(B3:H111,"Butterfly Charm")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"teetrinity" wrote in message
...
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 "butterfly charm" appears 12X during the year.

The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,"Butterfly
Charm")

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?

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.

"Bob Phillips" wrote:

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)

"teetrinity" wrote in message
...
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.

"Bob Phillips" wrote:

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

=COUNTIF(B3:H111,"Butterfly Charm")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"teetrinity" wrote in message
...
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 "butterfly charm" appears 12X during the year.

The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,"Butterfly
Charm")

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?

Glad you sorted it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"teetrinity" wrote in message
...
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.

"Bob Phillips" wrote:

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)

"teetrinity" wrote in message
...
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.

"Bob Phillips" wrote:

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

=COUNTIF(B3:H111,"Butterfly Charm")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"teetrinity" wrote in message
...
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 "butterfly charm" appears 12X during the year.

The formula is like this: =COUNTIF('2006
Calendar'!B3:H111,"Butterfly
Charm")

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?