| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Countif w/ Criteria
My data is arranged as so:
Date Time Product 20050208 93034 S1 20050208 93035 A6 20050208 93035 O0 20050208 93035 I1 20050208 93035 E5 20050208 93036 A5 20050208 93236 S7 20050208 93236 B7 20050208 93237 X3 Would like a formula to place in ColB of the table below that counts the number of products displayed for a given day between the times in ColA. For example, B3 would be counting the number of products between 93030 and 93100 including 93100. 20050208 93030 0 93100 6 93130 0 93200 0 93230 0 93300 3 Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions | |||
| Countif with dynamic criteria | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
| COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions | |||
| How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions | |||
Threaded Mode
