Help with IF formula for dates

[devilfinn]

Hello,

i have a problem sorting my data, and i think it can be done quite easily if one is good at excel and IF formulas. Here is a sample of my dataset:

01.02.2003... 2 ... -
01.02.2003... - ... 1
01.02.2003... - ... 2
01.03.2003... 2 ... -
01.03.2003... 2 ... -
01.03.2003... 2 ... -
01.03.2003... 1 ... -
01.04.2003... 3 ... -
01.04.2003... - ... 5
01.04.2003... - ... 2

What i wish to do is sum up for each date, column 2 - colum 3, giving me a summation of total column2 - column3 for each day of the year. i have several years worth of observations, so this has to be done automatically, in excel 2007.
There are not the same number of observations each day.

a wanted result would then be:
date ----------- c2 -- c3 - Sum
01.02.2003 ... 2... -
01.02.2003 ...- ...1
01.02.2003... -... 2 ... -1
01.03.2003... 2... -
01.03.2003... 2... -
01.03.2003... 2... -
01.03.2003... 1... - ... 7
01.04.2003 ... 3 ... -
01.04.2003 ... - .... 5
01.04.2003 ... - ... 2 ... -4

i know i was quite unclear, so please let me know if you dont understand what i mean.

thanks for any help you can give me,

best regards

Finn

[martindwilson]

use a pivot table
see attached
use another col d to get each difference into its own cell then

select data including headers
from insert tab
select pivot table
choose where you want it say existing worksheet f1
click ok

from the pivot table field list

drag and drop date into row field
drag and drop difference into data field
close the
pivot table field list
right click the pivot table
select pivot table options
on totals and filters tab
uncheck show grand totals for columns
click ok
the dropdown arrow in the date field
can be used to filter the table on any date or dates

[devilfinn]

thanks a lot! great help!

Finn