Remember Me?

#1
November 7th 04, 07:38 AM
 terryv Posts: n/a
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

#2
November 7th 04, 08:10 AM
 Biff Posts: n/a

Hi!

Just remove the quotes and the equal sign. "=A3"

=Countif(Times,A3)

When you put quotes around something Excel treats it as
text. In this case Excel was looking for the literal text
string of =A3.

Biff

-----Original Message-----
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

.

#3
November 8th 04, 09:03 AM
 terryv Posts: n/a

Thank you so much Biff
I was using the Sumif syntax ... kinda...

Again
Thank you

Terry

"Biff" wrote in message
...
Hi!

Just remove the quotes and the equal sign. "=A3"

=Countif(Times,A3)

When you put quotes around something Excel treats it as
text. In this case Excel was looking for the literal text
string of =A3.

Biff

-----Original Message-----
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

.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Sheryl Excel Discussion (Misc queries) 4 December 9th 04 07:18 PM reno Excel Worksheet Functions 5 November 5th 04 12:20 PM Angel160 Excel Worksheet Functions 2 November 3rd 04 05:23 PM Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM Liz G Excel Worksheet Functions 3 November 1st 04 09:34 PM

All times are GMT +1. The time now is 12:25 PM.