| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Counting Number of Occurences
How do I count the amount of lines that occur between times, i.e. 0001
through 0059, and so on through 2359? I have very large spreadsheets and have resorted to sorting by time and then highlighting the lines and seeing what the count states. |
|
#2
|
|||
|
|||
|
One way
=SUMPRODUCT(--(A1:A500=--"00:01"),--(A1:A500<=--"00:59")) -- Regards, Peo Sjoblom "Darren" wrote in message ... How do I count the amount of lines that occur between times, i.e. 0001 through 0059, and so on through 2359? I have very large spreadsheets and have resorted to sorting by time and then highlighting the lines and seeing what the count states. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
| countif number of occurences per month per year. | Excel Worksheet Functions | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
