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
- 67.6K Get Help
- 472 Global Discussions
- 200 Use Cases
- 513 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!