Formula Help

T

tsgprez

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?
 
G

Gary''s Student

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
 
T

tsgprez

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?
 
G

Gary''s Student

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
 
Top