| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
counting columns
I am creating a spreadsheet for a friend and need to be able to count all
rows in a column that contain the character "-". Here is what I am looking to do. Column A values 8:30/l 6:30 9-1 12-5 7:30 I need to know how many rows in column A have the format "#-#". In otherwords, I need to know how many rows in column A that contain a "-". |
|
#2
|
|||
|
|||
|
Try...
=COUNTIF(A1:A100,"*-*") Hope this helps! In article , "jpcblood" wrote: I am creating a spreadsheet for a friend and need to be able to count all rows in a column that contain the character "-". Here is what I am looking to do. Column A values 8:30/l 6:30 9-1 12-5 7:30 I need to know how many rows in column A have the format "#-#". In otherwords, I need to know how many rows in column A that contain a "-". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows of blanks across certain columns | New Users to Excel | |||
| excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
| Counting differences in numbers across columns | Excel Worksheet Functions | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
| counting in one column when two expressions in two other columns are true | Excel Worksheet Functions | |||
Hybrid Mode
