Revenue Formulas
Hello
I need to take our revenue and break it down into revenue per month, and revenue per quarter and return each value into a separate cell.
So take extended sell based on month (I have another column on my sheet called Date Shipped) and add it all up into a cell. Same for the quarterly.
I would be open to having the revenue calculated via a formula to a cell for each month then a formula to calculate it per quarter. That way I can see the per month total for future reference.
I'm not looking to do this via a report as I want it to populate other tings once the data is generated.
Thanks in advance
Comments
-
Hello,
I'm not exactly sure how your sheet is set up other than that bit in the screenshot, but you can do this in a few ways.
If you have a bookings/daily log sheet with totals, you can use a SUMIF or SUMIFS function to sum only the values that fall within a certain date range (using the DATE function as well).
More on these functions:
Here's our complete functions list: https://help.smartsheet.com/functions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives