How do I sum a range if the date is is greater than today's date?

S

S2

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
 
R

RagDyeR

Try this:

=SUMIF(B1:E1,">="&TODAY(),B2:E2)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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
 
B

Biff

Hi!

As long as the range B1:E1 are true Excel dates:

=SUMIF(B1:E1,">="&TODAY(),B2:E2)

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top