It is just a number not a minute. I just put the 'mins' there to help
illustrate what i was asking.

I got some help from Toppers with this formula.

"Mike" wrote:

If your B column is really 75mins as opposed to just the number 75 then you
will have a problem evaluating that and will need to extract the numeric part
before you can add it up.

=LOOKUP(9.99999999999999E+307,--LEFT(B1,ROW(INDIRECT("1:"&LEN(B1)))))

insterted in column C and dragged down will extract the numeric part from
column B. Then

=SUMPRODUCT((MONTH($A$1:$A$100)=1)*($C$1:$C$100))

will do the summing required. This formula will check for January so
substitute 2 for February etc.

Mike
"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