|Date: ||Tue, 27 Jun 2000 14:19:28 -0700|
|Reply-To: ||"Weidman, Marge - TP3MXW" <MWeidman@SOCALGAS.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Weidman, Marge - TP3MXW" <MWeidman@SOCALGAS.COM>|
|Subject: ||Re: excel question|
Have two columns of data: Date and Number.
Insert two more columns after 'Date' to say 'Month' and 'Year'.
You know have four columns of data 'Date' 'Month' 'Year' and 'Number'
Month is generated by =month(a1...a99.. etc) and year is generated by
Make sure there are no gaps in the dataset.
Use Pivot table to get sums by month (and by year- if you want to).
From: amit khandelwal [mailto:a-khandelwal@NORTHWESTERN.EDU]
Sent: Wednesday, May 10, 2000 5:10 PM
Subject: excel question
I have a series of data that are in chronological order from 1990-1999.
Associated with each day is number. Does anyone know in excel how I can sum
the numbers by month?