how to count the number of text frequencies and copy to other cell

[DG]

I am trying to use the COUNTIF function to count the number of text
frequencies on a line that match a "text phrase". then i am try to copy this
formula to 200 cells below. When i reference to a cell such as "+a15", where
cell +15 is the text that i want ot match against, the result is a blank
cell. I understand that if the match is zero times a blank cell will be the
result.

But if i copy the data is cell A15 to the function of COUNTIF I get the
correct result. Isn't there an easier to way to copy the function down
several rows.

[RagDyer]

If I understand your question, does this help:

=COUNTIF(B1:B100,$A$15)
?

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"DG" <[email protected]> wrote in message
news:[email protected]...
> I am trying to use the COUNTIF function to count the number of text
> frequencies on a line that match a "text phrase". then i am try to copy
this
> formula to 200 cells below. When i reference to a cell such as "+a15",
where
> cell +15 is the text that i want ot match against, the result is a blank
> cell. I understand that if the match is zero times a blank cell will be
the
> result.
>
> But if i copy the data is cell A15 to the function of COUNTIF I get the
> correct result. Isn't there an easier to way to copy the function down
> several rows.