Revenue Formulas

MRCNathan

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

 

Shaine Greenwood

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:

• SUMIF
• SUMIFS
• DATE

Here's our complete functions list: https://help.smartsheet.com/functions