Trying to get a total form the past 7 days from this formal
Trying to get a total form the past 7 days from this formal- =SUMIFS(Date submitted:Date submitted, <TODAY(-7),[Credit Amount]:[Credit Amount])
Best Answer
-
Hey
Try this
=SUMIFS([Credit Amount]:[Credit Amount], [Date submitted]:[Date submitted], >=TODAY(-7), [Date submitted]:[Date submitted], <=TODAY())
cheers,
Kelly
Answers
-
Hey
Try this
=SUMIFS([Credit Amount]:[Credit Amount], [Date submitted]:[Date submitted], >=TODAY(-7), [Date submitted]:[Date submitted], <=TODAY())
cheers,
Kelly
-
Thanks Kelly, You rock😎
How about if I wanted to count the number of entries I have for the past 7 days
-
Hey Joey
Thanks. I chose the above version of the formula so the syntax of the SumIfs formula was easily seen - range to be summed, range1, criteria1, range2, criteria2, range2, criteria3, etc.
If you preferred, a more streamlined formula (with same syntax)is
=SUMIFS([Credit Amount]:[Credit Amount], [Date submitted]:[Date submitted], AND(@cell>=TODAY(-7), @cell <=TODAY()))
Thanks for contributing your question to the community.
cheers
-
I am sorry, I was not clear. I am looking for the total number of rows, just a basic number of entries (rows) I have? The answer is 3, how do I get that
-
Hey
Sorry. Since you used the SUMIFs I assumed you wanted a sum. To get a Count when you have criteria, we use COUNTIFs.
COUNTIFs has the syntax range1, criteria1, range2, criteria2, etc
We can take the SUMIFs formula and get rid of that Sum range in the beginning to give us the COUNTIFS formula.
COUNTIFS([Date submitted]:[Date submitted], AND(@cell>=TODAY(-7), @cell <=TODAY()))
cheers,
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!