Forecasting amount across a monthly column based on frequency of sales

**eagleadam89** · 11-20-2014, 08:01 AM

Hi All,

Forgive me if I don't explain this clearly. I am looking for suggestions on how use a formula to forecast sales amount based on a frequency from a start date. I have attached an example of what i want to achieve if this helps to clarify. also the months across the top are on a rolling basis.

Thanks alot for you assistance

**Ron Coderre** · 11-20-2014, 10:03 AM

Using your sample workbook,
this regular formula, copied across and down, returns the Sales Amount if
• the referenced month is >= the Start Date
AND
• the referenced month satisfies the Frequency variable

Please Login or Register  to view this content.

Is that something you can work with?

**eagleadam89** · 11-20-2014, 10:07 AM

Hi Ron

Yes that works perfectly thank you very much

**Ron Coderre** · 11-20-2014, 10:23 AM

Glad you got something you can use!

If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)

Forecasting amount across a monthly column based on frequency of sales

LinkBack

Thread Tools

Rate This Thread

Display

Forecasting amount across a monthly column based on frequency of sales

Re: Forecasting amount across a monthly column based on frequency of sales

Re: Forecasting amount across a monthly column based on frequency of sales

Re: Forecasting amount across a monthly column based on frequency of sales

Thread Information

Users Browsing this Thread

Similar Threads

sum and frequency of data & sum of amount based on criteria

Sales Goals - using rolling 12 month sales and minimum monthly sales

Forecasting of sales based on conditions which impact over a period of time.

Transform an Excel sales table with multiple monthly sales column into an Access DB

Counting Based on Monthly Condition of Sales

Bookmarks

Bookmarks

Posting Permissions