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

one way:

=SUMPRODUCT(--(B1:B3=3),--(C1:C3<TIME(12,0,0)))



In article ,
"Anthony" wrote:

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

thanks JE McGimpsey it worked !!

rgds
Anthony

"JE McGimpsey" wrote:

one way:

=SUMPRODUCT(--(B1:B3=3),--(C1:C3<TIME(12,0,0)))



In article ,
"Anthony" wrote:

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