=SUMPRODUCT(--(CHOOSE(MONTH($B$1:$B$7),"Jan","Feb","Mar")=E1),$DT$1:$DT$7)

confirm with control shift enter

Mangesh





"Minitman" <exreply@i-m-pNOSPAM.net> wrote in message
news:fg5qa11sevd033si63f3q4uiho3cj71aoi@4ax.com...
> Hey Mangesh,
>
> B DT
> 3 1/20/04 $4.00
> 4 1/21/04 $3.00
> 5 1/29/04 $2.00
> 6 2/14/04 $1.00
> 7 3/12/04 $11.00
> 8 3/16/04 $6.00
> 9 2/22/04 $20.00
>
>
> On a different sheet:
>
> Month Amount
> Jan (Formula goes here, should return $9.00)
> Feb (Formula goes here, should return $21.00)
> Mar (Formula goes here, should return $17.00)
>
> That is what I am trying to do
>
> Any suggestions?
>
> -Minitman
> On Mon, 13 Jun 2005 10:33:55 +0530, "Mangesh Yadav"
> <m6angesh.NOSPAMyadav@gmail.com> wrote:
>
> >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
> >
>