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
|
|||
|
|||
How do I sum a range if the date is is greater than today's date?
Greetings - trying to evaluate a range of cells that contain dates, and if
the date is equal to or greater than today's date, sum a second range of cells: : Table: A B C D E 1 10/6 10/7 10/8 10/9 2 1 5 10 15 I would think the formula: sumif(B1:E1,=today(),B2:E2) ... should return "25" - the sum of cells D2 and E2 because cells D1 and E1 are equal to or greater than today's date. However, no love from Excel. Error message focus points out my criteria, or the "today()" function. I have also tried "now()" with no luck. Any ideas? Thanks! S2 |
#2
|
|||
|
|||
Try this:
=SUMIF(B1:E1,"="&TODAY(),B2:E2) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "S2" wrote in message ... Greetings - trying to evaluate a range of cells that contain dates, and if the date is equal to or greater than today's date, sum a second range of cells: : Table: A B C D E 1 10/6 10/7 10/8 10/9 2 1 5 10 15 I would think the formula: sumif(B1:E1,=today(),B2:E2) ... should return "25" - the sum of cells D2 and E2 because cells D1 and E1 are equal to or greater than today's date. However, no love from Excel. Error message focus points out my criteria, or the "today()" function. I have also tried "now()" with no luck. Any ideas? Thanks! S2 |
#3
|
|||
|
|||
Hi!
As long as the range B1:E1 are true Excel dates: =SUMIF(B1:E1,"="&TODAY(),B2:E2) Biff "S2" wrote in message ... Greetings - trying to evaluate a range of cells that contain dates, and if the date is equal to or greater than today's date, sum a second range of cells: : Table: A B C D E 1 10/6 10/7 10/8 10/9 2 1 5 10 15 I would think the formula: sumif(B1:E1,=today(),B2:E2) ... should return "25" - the sum of cells D2 and E2 because cells D1 and E1 are equal to or greater than today's date. However, no love from Excel. Error message focus points out my criteria, or the "today()" function. I have also tried "now()" with no luck. Any ideas? Thanks! S2 |
#4
|
|||
|
|||
Brilliant! Works perfectly - thanks!! - S2
"Biff" wrote: Hi! As long as the range B1:E1 are true Excel dates: =SUMIF(B1:E1,"="&TODAY(),B2:E2) Biff "S2" wrote in message ... Greetings - trying to evaluate a range of cells that contain dates, and if the date is equal to or greater than today's date, sum a second range of cells: : Table: A B C D E 1 10/6 10/7 10/8 10/9 2 1 5 10 15 I would think the formula: sumif(B1:E1,=today(),B2:E2) ... should return "25" - the sum of cells D2 and E2 because cells D1 and E1 are equal to or greater than today's date. However, no love from Excel. Error message focus points out my criteria, or the "today()" function. I have also tried "now()" with no luck. Any ideas? Thanks! S2 |
#5
|
|||
|
|||
Brilliant! Works perfectly - thanks!! - S2
"RagDyeR" wrote: Try this: =SUMIF(B1:E1,"="&TODAY(),B2:E2) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "S2" wrote in message ... Greetings - trying to evaluate a range of cells that contain dates, and if the date is equal to or greater than today's date, sum a second range of cells: : Table: A B C D E 1 10/6 10/7 10/8 10/9 2 1 5 10 15 I would think the formula: sumif(B1:E1,=today(),B2:E2) ... should return "25" - the sum of cells D2 and E2 because cells D1 and E1 are equal to or greater than today's date. However, no love from Excel. Error message focus points out my criteria, or the "today()" function. I have also tried "now()" with no luck. Any ideas? Thanks! S2 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HELP - Date Range In 1 Cell Calculation | Adam | Worksheet Functions | 6 | September 19th, 2005 08:24 PM |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
How do I create a schedule from a list of dates ? | Gavin Morris | Charts and Charting | 1 | June 22nd, 2005 12:24 PM |
Returning a dynamic date range | Ali | Running & Setting Up Queries | 2 | February 21st, 2005 02:55 PM |
Cancel print on subreport based on date range | Miss Kait | Setting Up & Running Reports | 4 | October 11th, 2004 03:19 PM |