Syntax help with date calculation

[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

 

[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