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