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?