M
Marcie4
I'm trying to figure out the proper calculation to pull totals by dat
in Excel. Here's my problem:
I have a workbook with 2 worksheets; one is the main data, the other i
the statistics from the main data. Within the main data, there is
column titled "date paid" and another column titled "total paid" (ther
are a bunch more columns, but they don't matter for this problem). Th
"date paid" column will contain dates such as 1/1/04, 5/15/04 etc. O
the stats page, I have columns titled for each month of the year an
would like each to include how much was paid for each month from th
main data worksheet.
For example:
On the main data page I have
date paid total paid
1/1/04 $500
1/15/04 $200
2/3/04 $100
3/30/04 $300
Here's how my stats page SHOULD look, but I can't make it:
January February March
$700 $100 $300
How can I get the totals to come over by month?
Any help would be GREATLY appreciated
in Excel. Here's my problem:
I have a workbook with 2 worksheets; one is the main data, the other i
the statistics from the main data. Within the main data, there is
column titled "date paid" and another column titled "total paid" (ther
are a bunch more columns, but they don't matter for this problem). Th
"date paid" column will contain dates such as 1/1/04, 5/15/04 etc. O
the stats page, I have columns titled for each month of the year an
would like each to include how much was paid for each month from th
main data worksheet.
For example:
On the main data page I have
date paid total paid
1/1/04 $500
1/15/04 $200
2/3/04 $100
3/30/04 $300
Here's how my stats page SHOULD look, but I can't make it:
January February March
$700 $100 $300
How can I get the totals to come over by month?
Any help would be GREATLY appreciated