View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Running Totals for Dates

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