Thank you for you help!

"Bob Phillips" wrote in message
...
You can do both.

In A1:An, list your criteria.

In B1, add =COUNTIF(Sheet2!$A$2:$A$1000,$A1)

and copy down


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ben" wrote in message
...
I have a formula that is looking at a range of cells on a second
worksheet
in a workbook. The cell range is A2:A1000, the formula is looking at the
range, and counting the number of times a certain value appears.

=COUNTIF(Sheet2!A2:A1000,"THING")

There are currently 116 different values in this cell range that I need
statistics on, what I want to do is create one forumla and copy it 115
times
WITHOUT the cell numbers changing in relation to where the formula is
copied. For example, if I copy the formula from A1 to D20 on any given
worksheet, the formula will be changed to:

=COUNTIF(Sheet2!D21:D1019,"THING")

I know that I will have to edit each formula to change the search
criteria,
but I don't want to have to spend the time changing the cell numbers on
top
of the value to be counted, or creating a formula from scratch for each
value.

Can someone help me?