If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting Dates
I get a report every day that lists a large number of
events by date. There are many per date and I would like a formula that counts the number of times a date is repeated. I would also like to take it one step further and count the number of times an event happens per date. Any suggestions? |
#2
|
|||
|
|||
=COUNTIF(A1:A26,"01/02/03") will tell you how many times the date 01/02/03
occurs in the range A1:A26 =SUMPRODUCT((A1:A26=1/2/3)+(B1:B26="event1")) will tell you how manytimes on that date a corresponding "Event1" showed up in range B1:B26 Vaya con Dios, Chuck, CABGx3 "Jerry" wrote in message ... I get a report every day that lists a large number of events by date. There are many per date and I would like a formula that counts the number of times a date is repeated. I would also like to take it one step further and count the number of times an event happens per date. Any suggestions? |
#3
|
|||
|
|||
Sorry, the first one is fine, but the second one fell apart with more
testing, and I'm about to fall off my chair right now, so can't go on tonight........hopefully someone else will pick up on it for you, or I will try again tomorrow...... Vaya con Dios, Chuck, CABGx3 "CLR" wrote in message ... =COUNTIF(A1:A26,"01/02/03") will tell you how many times the date 01/02/03 occurs in the range A1:A26 =SUMPRODUCT((A1:A26=1/2/3)+(B1:B26="event1")) will tell you how manytimes on that date a corresponding "Event1" showed up in range B1:B26 Vaya con Dios, Chuck, CABGx3 "Jerry" wrote in message ... I get a report every day that lists a large number of events by date. There are many per date and I would like a formula that counts the number of times a date is repeated. I would also like to take it one step further and count the number of times an event happens per date. Any suggestions? |
#4
|
|||
|
|||
Hi!
Dates in column A Events in column B =SUMPRODUCT(--(A1:A20=DATE(2005,1,1)),--(B1:B20="event")) OR enter a date in C1: =SUMPRODUCT(--(A1:A20=C1),--(B1:B20="event")) Biff -----Original Message----- Sorry, the first one is fine, but the second one fell apart with more testing, and I'm about to fall off my chair right now, so can't go on tonight........hopefully someone else will pick up on it for you, or I will try again tomorrow...... Vaya con Dios, Chuck, CABGx3 "CLR" wrote in message ... =COUNTIF(A1:A26,"01/02/03") will tell you how many times the date 01/02/03 occurs in the range A1:A26 =SUMPRODUCT((A1:A26=1/2/3)+(B1:B26="event1")) will tell you how manytimes on that date a corresponding "Event1" showed up in range B1:B26 Vaya con Dios, Chuck, CABGx3 "Jerry" wrote in message ... I get a report every day that lists a large number of events by date. There are many per date and I would like a formula that counts the number of times a date is repeated. I would also like to take it one step further and count the number of times an event happens per date. Any suggestions? . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Calculate Dates without counting the weekends | Lillian F | Worksheet Functions | 9 | January 24th, 2005 09:09 AM |
Excel: counting cells which have dates between specified dates | Jacqueline | General Discussion | 2 | August 11th, 2004 12:15 PM |
counting the number of dates | GORDON | General Discussion | 2 | June 23rd, 2004 04:58 AM |
Counting dates & Times | Willem | Worksheet Functions | 1 | January 8th, 2004 11:35 AM |