Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|