Hi all,
Third new post for me.
I have two columns. One with dates including the time stamp on them. The other with amounts for those dates.
Date Result
Sun, Jan 30, 2011, 3 AM $289.78
Sun, Jan 30, 2011, 7 AM $290.78
Sun, Jan 30, 2011, 11 AM $231.34
Mon, Jan 31, 2011, 3 PM $23.78
Mon, Jan 31, 2011, 7 PM $143.12
How can I add all the amounts posted on Jan 30 regardless of the time?
For example, for Jan 30 I should add
$289.78
$290.78
$231.34
Also note that the list of dates and amounts includes zeros.
Thanks in advance.
luix
Bookmarks