View Single Post
  #7   Report Post  
bj
 
Posts: n/a
Default

one of the things that might be happening is that the name as shown may not
be the name as listed:
try
Try =countif(G1:G3000,G112)

(or "F as required to get the right column)

"ww" wrote:

what exactly do you have for a formula?

"kamill" wrote:

I tried that but its still not working. It shows zero as my total.

I even copied the formula that "ww" gave me and used that and it still gives
me zero.

Thanks for your help.

"bj" wrote:

I'm not sure if the names are in f or g. Use the column with the names.

"kamill" wrote:

Thanks "ww"

I tried it but I'm getting zero. columns a-f have other information while
the name of my person is in column f.

would I just replace the a with a g?


"ww" wrote:

Try =countif(A1:A3000,"name of person")

"kamill" wrote:

My spreadsheet has 3000 entries and I'm trying to add the number of rows for
one person.

Example -

Row 112
Row 114
Row 899
Row 1021
Row 1033

Can you help?