Assume column X has a list of dates (1-Jan, 2-Jan etc) starting row 2

Put this formula in Y2 and copy down for all dates in column X

=SUMPRODUCT(--($A$2:$A$100=X2),($F$2:$F$100))

Change range of A and F to suit but they cannot be a total column (A:A is
not valid)

HTH

"censura" wrote:

just totaled by each dat
--
thank you
censura


"Toppers" wrote:

Do you want by Date only or Date AND Currency?

Take a look at Pivot Tables which might meet you need.

"censura" wrote:

Toppers hope you can help it is a similar to the previous thread you helped
with.
I have two columns a and f a has dates in it ie 02-jan , 02-jan, 03-jan with
trades taken that day across different currencies thus

02-jan -20 gbp
02-Jan +45 chf
02-Jan -11 eur
03-jan +34 gbp

What i would like to do is habe totals for each day and then this data
imported into a equity graph. I would also like the graph to be updated as
new entries are made each day and added to the table.

hope you can help
thank you
--
thank you
censura


"Toppers" wrote:

With dates in column A and times in B:

=SUMPRODUCT((MONTH($A$1:$A$5)=1)*($B$1:$B$5))

will give total for January ... and this for February

=SUMPRODUCT((MONTH($A$1:$A$5)=2)*($B$1:$B$5))

HTH


"Chart_Maker_Wonderer" wrote:

I am making a spread sheet that lists meeting times. One line will show the
specific date the next column shows the length of the meeting.

What I would like to do is to have a way to have a formula that will add the
times for the months together.

Example:
Jan-12 75mins
Jan-22 25mins
Feb-1 10mins
Mar-16 15mins
Feb-5 25mins

I want to have it so in another section it will display these results
Jan - 100mins
Feb - 15mins
Mar - 15mins