SUM by Month with IF Statement

[kiyo052]

I need a formula for E2 and F2

In E2, I need the sum of the amounts of February.
Also, if Column B says "TEAM" then divide the amount by 2.
So E2 total should be 450 because 200+200+(100/2)

In F2, I need the sum of the amounts of March.
Also, if Column B says "TEAM" then divide the amount by 2.
So F2 total should be 150 because (100/2)+(100/2)+(100/2)


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]Plan[/TD]
[TD="align: center"]Amount[/TD]
[TD="align: center"][/TD]
[TD="align: center"]February[/TD]
[TD="align: center"]March[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]2/20[/TD]
[TD="align: center"]Team[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"][/TD]
[TD="align: center"]450[/TD]
[TD="align: center"]150[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]2/22[/TD]
[TD="align: center"]Biz[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]2/25[/TD]
[TD="align: center"]Biz[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]3/1[/TD]
[TD="align: center"]Team[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]3/5[/TD]
[TD="align: center"]Team[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]3/6[/TD]
[TD="align: center"]Team[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Try this if the current year can be assumed for the month strings written in F1 and G1

=SUM(SUMIFS($D$2:$D$7,$B$2:$B$7,">="&F$1&1,$B$2:$B$7,"<="&EOMONTH(F$1&1,0),$C$2:$C$7,{"Team","<>Team"})/{2,1})

 

[kiyo052]

Thank you so much!

Would it be possible to add one more criteria as well? If it says Team OR Monthly, divide the amount by 2.

Please let me know if this is possible.

Thank you for your help!!!