I have month in one column many times by a different product i.e. January,
February, March etc.....in another column I have date sale kicked in say
March.
In another column I have projected sales for one month. How can I have the
worksheet convert the month to a number so I can calculate sales for December
minus the month I started the sale of a product i.e. if we started in March
this would be projected at 12-3 or 9 months of sales times the amount of the
sales per month. I need to do this for multiple products and cannot figure
out how you use a month that someone keys into a spreadsheet in a calculation
since it could change each line by line.

Any help is much appreciated.

I can assist you but it is difficult until I see the data or a sample of it.
However, let's assume that cell A1 contains month "March" now in order to
convert this into serial number write the following formula in cell A2
=MONTH(1&A1)
The result will be 3. Make sure you write the formula exactly as shown above.

--
Axim5


"wchurchi" wrote:

I have month in one column many times by a different product i.e. January,
February, March etc.....in another column I have date sale kicked in say
March.
In another column I have projected sales for one month. How can I have the
worksheet convert the month to a number so I can calculate sales for December
minus the month I started the sale of a product i.e. if we started in March
this would be projected at 12-3 or 9 months of sales times the amount of the
sales per month. I need to do this for multiple products and cannot figure
out how you use a month that someone keys into a spreadsheet in a calculation
since it could change each line by line.

Any help is much appreciated.

The description of the problem is unclear.

From what I gather, you have historical sales and projected sales. There
are several ways to arrange the information to get the reports you want.

Some folks put sales and projections in 2 separate tables. A table would
look as follows:

Jan 01 Feb 01 Mar 01 etc....
Prod1
Prod2
Prod3
etc...

Then comparisons between the two tables are made to show projection versus
actual sales.

Many combine projection and historical sales together.

You can easily get summaries of sales/projections on the fly by month,
quarter, 6-months or annual. Takes some creativity with the SUM() function
and OFFSET() function.

But before anyone can go into more detail, you need to describe the problem
better.

g-

___________________________________

I need holiday money. Got any jobs, big or small, drop me a line! Thanks!

Hey Axim5----Thanks so much you solved my problem----Many Many thanks I have
been working on this for four hours---Thanks again very much.....Calculations
now work the 1& in the formula made the difference...Wow great help....

"Axim5" wrote:

I can assist you but it is difficult until I see the data or a sample of it.
However, let's assume that cell A1 contains month "March" now in order to
convert this into serial number write the following formula in cell A2
=MONTH(1&A1)
The result will be 3. Make sure you write the formula exactly as shown above.

--
Axim5


"wchurchi" wrote:

I have month in one column many times by a different product i.e. January,
February, March etc.....in another column I have date sale kicked in say
March.
In another column I have projected sales for one month. How can I have the
worksheet convert the month to a number so I can calculate sales for December
minus the month I started the sale of a product i.e. if we started in March
this would be projected at 12-3 or 9 months of sales times the amount of the
sales per month. I need to do this for multiple products and cannot figure
out how you use a month that someone keys into a spreadsheet in a calculation
since it could change each line by line.

Any help is much appreciated.