Nigel P;392126 Wrote:
I would like to summarise data by date for example
A1 B1 - Date, Value
1/2/9 10
1/2/9 12
2/2/9 34
3/2/9 27
4/2/9 56

with results in another range of cells:
1/2/9 22
2/2/9 34
3/2/9 27
4/2/9 56

If your dates are truly sequential like that... then you can enter the
first date somewhere and fill down the column to get the sequential
dates...then in adjacent column, use SUMIF...

e.g =Sumif($A$1:$A$100,X1,$B$1:$B$100)

where A1:B100 contain your original table of dates/values and X1
contains first date to summarize...

... alternatively look into Pivot tables... (Google Pivot Tables
Tutorials, and similar).


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109598