Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting Cells with time value
Hi,
I wish to count the times that a column (lets say column 'C') shows a time that is before 12:00, but only count this cell if the value of the cell adjacent is a certain number. example :- Coulmns A B C Row 1 3 11:23 Row 2 2 09:00 Row 3 3 14:55 So in the example I want to show how many times the value in column C is before 12:00 when the value in column B = 3 - the answer given would be 1 Hope this is clear, and thanks in advance Anthony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting text cells | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
split combined Time Date cells | Excel Discussion (Misc queries) | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions |