Formula Help
 

I have created a spreadsheet that allows users to enter their sales and the
date of their sales. I want to create a summary sheet that will calculate
total sales by month (date). How do I do that?

Formula Help
 

Say the sales are in column A starting at A2
and the date is in column B strating at B2
then in C2 enter:
=MONTH(B2)
and copy down
Column C will be the month of the sale.

Then create a Pivot Table of the sum of sales by month. If you are not
familiar with pivot tables, see:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


--
Gary''s Student - gsnu200718

Formula Help
 

Thanks Gary. I tried your suggestion and I am getting a #VALUE! error in
column C2. Does it matter that I have created a pulldown for the date in
Column B2?

"Gary''s Student" wrote:

Say the sales are in column A starting at A2
and the date is in column B strating at B2
then in C2 enter:
=MONTH(B2)
and copy down
Column C will be the month of the sale.

Then create a Pivot Table of the sum of sales by month. If you are not
familiar with pivot tables, see:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


--
Gary''s Student - gsnu200718

Formula Help
 

Should not matter as long as the dates in column B are "real" dates. Try to
enter a date in column B manually and see what happens
--
Gary''s Student - gsnu200718


"tsgprez" wrote:

Thanks Gary. I tried your suggestion and I am getting a #VALUE! error in
column C2. Does it matter that I have created a pulldown for the date in
Column B2?

"Gary''s Student" wrote:

Say the sales are in column A starting at A2
and the date is in column B strating at B2
then in C2 enter:
=MONTH(B2)
and copy down
Column C will be the month of the sale.

Then create a Pivot Table of the sum of sales by month. If you are not
familiar with pivot tables, see:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


--
Gary''s Student - gsnu200718