| 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 |
|---|
|
| Content-Type: | multipart/alternative;
|
|---|
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
=year(a1..a99..etc).
Make sure there are no gaps in the dataset.
Use Pivot table to get sums by month (and by year- if you want to).
-----Original Message-----
From: amit khandelwal [mailto:a-khandelwal@NORTHWESTERN.EDU]
Sent: Wednesday, May 10, 2000 5:10 PM
To: SAS-L@LISTSERV.UGA.EDU
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?
THANKS!!!!
amit
[text/html]
| 
