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
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