# countif problem in 2k

#### hbrucep

##### New Member
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
ABCD
11/23/0510:31PMEVERETT
21/23/0510:35PMRENTON
31/23/0510:35PMISSAQUAH
41/23/0511:41PMEDGEWOOD
51/23/0511:47PMKIRKLAND
61/24/0512:17AMMOUNTVERNON
71/24/0512:21AMLACEY
81/24/0512:45AMAUBURN
91/24/051:19AMBELLINGHAM
Sheet1

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Try,

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

or sub the date for a cell referenece

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

hbrucep said:
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?

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

hbrucep said:
neither of those worked. The answer for the 24th would be 4 in my example.
Book5
ABCDEF
11/23/200522:31EVERETT1/24/2005TRUE
21/23/200522:35RENTON4TRUE
31/23/200522:35ISSAQUAHTRUE
41/23/200523:41EDGEWOODTRUE
51/23/200523:47KIRKLANDTRUE
61/24/20050:17MOUNTVERNONTRUE
71/24/20050:21LACEYTRUE
81/24/20050:45AUBURNTRUE
91/24/20051:19BELLINGHAMTRUE
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<>""))

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

Replies
4
Views
155
Replies
2
Views
145
Replies
1
Views
565
Replies
3
Views
577
Replies
12
Views
2K

1,221,424
Messages
6,159,825
Members
451,592
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back