Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Btwn to date entries
Firstly, Thanks Frank it works like a dream. =SUMPRODUCT(--(B1:B100<""),--(A1:A100<""),--(B1:B100<=TODAY())) I thought I could work the rest by myself but I have another question. I am now trying to add up the number of rows which have date entries from two columns, which using the current date is on or after column B and before or on column C, and only if there is an entry on the same row in another specified column A. for example A B c 1 x 12/12/2004 14/12/2005 2 3 r 10/10/2004 12/12/2004 4 t The total for this would be 1 (row 3) Many Thanks again |
#2
|
|||
|
|||
Hi
try: =SUMPRODUCT(--(B1:B100<""),--(A1:A100<""),--(C1:C100<"")--(B1:B100= TODAY()),--(C1:C100<=TODAY())) -- Regards Frank Kabel Frankfurt, Germany "dave" schrieb im Newsbeitrag ... Firstly, Thanks Frank it works like a dream. =SUMPRODUCT(--(B1:B100<""),--(A1:A100<""),--(B1:B100<=TODAY())) I thought I could work the rest by myself but I have another question. I am now trying to add up the number of rows which have date entries from two columns, which using the current date is on or after column B and before or on column C, and only if there is an entry on the same row in another specified column A. for example A B c 1 x 12/12/2004 14/12/2005 2 3 r 10/10/2004 12/12/2004 4 t The total for this would be 1 (row 3) Many Thanks again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
counting specified date entries | Excel Worksheet Functions | |||
Count data entries and date problem | Excel Worksheet Functions |