SUM within a date range
Hi,
I have 2 columns, 1 is a purchase amount, and the second is a purchase date. I'm looking to create a table from this that breaks down total amount purchased by quarter.
I've tried the following among a few other variations with no luck:
Q1: SUMIFS([Purchase]1:[Purchase]34, [Purchase Date]1:[Purchase Date]34, >=DATE(2021,1,1),[Purchase Date]1:[Purchase Date]34, <=DATE(2021,4,1))
It doesn't give me an error but it doesn't calculate properly
Answers
-
The formula worked great for me as is, but make sure your date column is formatted as such. You'll get a zero if it's formatted as a text column. If it's already formatted as a date column, maybe someone else can advise.
-
Thanks John, yeah it was working for me as well when I tested it but not working when I try to actually apply it to the group of data I'd like it to pull from it is just returning 0s. I do have it set up as a date column is why I'm confused. Thanks!
-
Hi @jose7895
How is your Purchase column being populated? Is it possible that the formula is seeing these values as text and not numerical values, which is why you're getting 0? If the Purchase column is using a formula to generate values, it would be helpful to know what this is!
Thanks,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives