Count rows not in sequence
 

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?

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?

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?

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?

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?

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?

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?