Summing Data by Date
Put headers for your data. Use advanced filter to generate unique records to
say Col D
DataFilterAdvanced FilterSelect Copy to another location..Select the list
range, Mention 'copy to' as (say cell D1). Check "Unique Records only'..OK
In E2 use the below formula and copy that down
=SUMIF(A:A,D2,B:B)
If this post helps click Yes
---------------
Jacob Skaria
"Nigel P" 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
|