#1   Report Post  
Old November 7th 04, 07:38 AM
terryv
 
Posts: n/a
Default 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   Report Post  
Old November 7th 04, 08:10 AM
Biff
 
Posts: n/a
Default

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   Report Post  
Old November 8th 04, 09:03 AM
terryv
 
Posts: n/a
Default

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


.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal And Countif Sheryl Excel Discussion (Misc queries) 4 December 9th 04 07:18 PM
countif reno Excel Worksheet Functions 5 November 5th 04 12:20 PM
Countif, Sumif, If - help! Angel160 Excel Worksheet Functions 2 November 3rd 04 05:23 PM
countif, again Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM
combining countif formulas Liz G Excel Worksheet Functions 3 November 1st 04 09:34 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017