Function Help - COUNTIF

[teetrinity]

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?

 

[Bob Phillips]

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]

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]

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]

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]

Glad you sorted it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)