CountIF Function Help!!

[Tina STL]

I am using the countif to tell me how many times text appears in column. The
problem I have is the return seems to be counting down, I need the return to
show the total number of times it appears on each line. I hope that makes
sense.

 

[Luke M]

What do you mean it 'counts down'?
the formula:
=COUNTIF(A:A,"Cat")
Would normally give you a count of how many times the word "Cat" appears in
column A. What does your formula/data look like that it is not doing what you
want?

 

[Tina STL]

# Manager Name
8 SIDNEY GRANT
7 SIDNEY GRANT
6 SIDNEY GRANT
5 BALLINGER HOLLOWAY HARMAN
5 SIDNEY GRANT
4 BALLINGER HOLLOWAY HARMAN
4 SIDNEY GRANT
Here is the examplet of the return. My Formula is =COUNTIF(B2:B447,B2).
What I was hoping for is each time Sidney Grant appears on the spreadsheet it
would return 8. Does this make sense? Thank you for any help you can give
me, I really appreciate it.

 

[Luke M]

Looks like your formula is floating when you fill down. Change it to:

=COUNTIF(B$2:B$447,B2)

The dollar signs will lock the formula onto those rows, so the array won't
move when you copy down.

 

[Tina STL]

Thank you SO much. That worked great!!!

Looks like your formula is floating when you fill down. Change it to:

=COUNTIF(B$2:B$447,B2)

The dollar signs will lock the formula onto those rows, so the array won't
move when you copy down.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*