Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Rows with Conditional Format? | Excel Discussion (Misc queries) | |||
Reduce columns and rows count? | Excel Worksheet Functions | |||
Count Rows with two criteria | Excel Worksheet Functions | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Count rows based on multiple criteria | Excel Worksheet Functions |