Give example of your data and expected answer.

Mangesh


"Minitman" <exreply@i-m-pNOSPAM.net> wrote in message
news:4q3qa19nau65sh6e7j57ct6jgltmju59m7@4ax.com...
> Greetings,
>
> I am trying to get the sum for each month in a column which has thee
> entire year.
>
> So far I have:
>
> SUMIF($B:$B,{need month and year here},$DT:$DT)
>
> B is formatted as mm/dd/yy I need mm/yy in the formula. I can't
> remember how to do this! Anyone have any ideas?
>
> Any help would be appreciated.
>
> TIA
>
> -Minitman