countif problem in 2k

[hbrucep]

What I need to do is find out how many of the line items are "today". This list grows during the day and I made a coversheet to tell how many items are happening today but also keep a record of past events. I tried using a countif(a:a,... but just not quite getting the equation right.

Book1
	A	B	C	D
1	1/23/0510:31PM	EVERETT
2	1/23/0510:35PM	RENTON
3	1/23/0510:35PM	ISSAQUAH
4	1/23/0511:41PM	EDGEWOOD
5	1/23/0511:47PM	KIRKLAND
6	1/24/0512:17AM	MOUNTVERNON
7	1/24/0512:21AM	LACEY
8	1/24/0512:45AM	AUBURN
9	1/24/051:19AM	BELLINGHAM
Sheet1

 

[Brian from Maui]

Try,

=COUNTIF(A:A,"1/24/2005")

or sub the date for a cell referenece

 

[hbrucep]

I need to make it variable so that is tracks to the current day, whatever that may be.

 

[Aladin Akyurek]

What I need to do is find out how many of the line items are "today". This list grows during the day and I made a coversheet to tell how many items are happening today but also keep a record of past events. I tried using a countif(a:a,... but just not quite getting the equation right.

...

Is this...

=SUMPRODUCT(--(INT($A$2:$A$10)=TODAY()),--($B$2:$B$10<>""))

what you're looking for?

 

[hbrucep]

neither of those worked. The answer for the 24th would be 4 in my example.

 

[Aladin Akyurek]

neither of those worked. The answer for the 24th would be 4 in my example.

Book5
	A	B	C	D	E	F
1	1/23/200522:31	EVERETT		1/24/2005		TRUE
2	1/23/200522:35	RENTON		4		TRUE
3	1/23/200522:35	ISSAQUAH				TRUE
4	1/23/200523:41	EDGEWOOD				TRUE
5	1/23/200523:47	KIRKLAND				TRUE
6	1/24/20050:17	MOUNTVERNON				TRUE
7	1/24/20050:21	LACEY				TRUE
8	1/24/20050:45	AUBURN				TRUE
9	1/24/20051:19	BELLINGHAM				TRUE
Sheet1

The date/time values must be true date/time values, each of which ISNUMBER is true.

D4:

=SUMPRODUCT(--(INT(A1:A9)=D1),--(B1:B9<>""))

 

[hbrucep]

I got it to work after I excluded the header. THANKS!!!!!