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
|