Syntax help with date calculation

O

Orion4MJ

I hope to sum certain cells based on their projected due dates, but can not
figure out how to do it. I think this can be done with SUMIF. The 5
groupings I need to sum are within 30 days, 60 days, 90days , 90+ days, and
"past due"

Column H contains the close date. Column G contains the $ values.

Here's what I've done but think I am way off base.


=SUMIF(H:H,"<=Today()+30",G:G)
=SUMIF(H:H,"<=Today()+60",G:G)
=SUMIF(H:H,"<=Today()+90",G:G)
=SUMIF(H:H,">Today()+90",G:G,))
=SUMIF(H:H,"<Today()",G:G)

Thanks
 
R

Ron Rosenfeld

I hope to sum certain cells based on their projected due dates, but can not
figure out how to do it. I think this can be done with SUMIF. The 5
groupings I need to sum are within 30 days, 60 days, 90days , 90+ days, and
"past due"

Column H contains the close date. Column G contains the $ values.

Here's what I've done but think I am way off base.


=SUMIF(H:H,"<=Today()+30",G:G)
=SUMIF(H:H,"<=Today()+60",G:G)
=SUMIF(H:H,"<=Today()+90",G:G)
=SUMIF(H:H,">Today()+90",G:G,))
=SUMIF(H:H,"<Today()",G:G)

Thanks

You're very close:

=SUMIF(H:H,"<="&TODAY()+30,G:G)


--ron
 

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