Formula calculating revenue for Q2

I am trying to calculate revenue for Q2 only for a given property
Here's what i had in the cell
=SUMIFS({Garden Grove Bill Rate}, {Garden Grove Inv Date}, YEAR(@cell) = YEAR(TODAY()), {Garden Grove Inv Date}, MONTH(@cell) > 3).
But that formula doesnt work now that we are in july. as it calculates july revenue as well.
So this is what i changed it to
=SUMIFS({Creekwood Apartments Bill Rate}, {Creekwood Apartments Inv Date}, YEAR(@cell) = YEAR(TODAY()), {Creekwood Apartments Inv Date}, MONTH(@cell) > 3, {Creekwood Apartments Inv Date}, MONTH(@cell) < 7)
Just wandering if there is an easier way, other than adding another @row reference. Can i use a date range with an @row reference that would express months 3-6?
thanks,
SGF
Comments
-
Try this:
=SUMIFS({Garden Grove Bill Rate}, {Garden Grove Inv Date}, >=DATE(2019, 4, 1), {Garden Grove Inv Date}, <=DATE(2019, 6, 30))
-
When referencing the same range twice within a SUMIFS, you can use the AND function to help save yourself from having to duplicate the range.
.
=SUMIFS({Creekwood Apartments Bill Rate}, {Creekwood Apartments Inv Date}, AND(YEAR(@cell) = YEAR(TODAY()), MONTH(@cell) > 3, MONTH(@cell) < 7))
-
Excellent.
Thanks guys! Works great! and saves me a few key strokes.
Thanks
Steve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 154 Industry Talk
- 502 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!