Countif ???
Hello
Im not sure what the problem is that Im having, I thought I was doing the
function right.
I have a worksheet where I need to look a time value up from another sheet
(also time values), and Im using the Countif function.
EX:
Sheet1
Col C
Values from 7:00 am to 6:30 am (could be many instances of each time
inbetween (inclusive).
Sheet2
Col A
Values 7:00 am to 6:30 am (only one instance of each time inclusively).
Formatted as Time 13:30
Sheet2
Col B
Should be a count of all values from Sheet 1 that match the value on Sheet 2
Col A. (formatted as Time 13:30)
When I do the Countif, I get a value of 0 (formatted to number with 0
decimals).
I have
=Countif(Times,"=A3")
But it returns 0. Times is a range name representing Sheet1 C1:C821 (I
double checked to make sure the range name was pointing to the proper
range).
Any suggestions?
Thank you
Terry V
|