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)
<tbody>
</tbody>
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)
A | B | C | D | E | F | |
1 | Date | Plan | Amount | February | March | |
2 | 2/20 | Team | 100 | 450 | 150 | |
3 | 2/22 | Biz | 200 | |||
4 | 2/25 | Biz | 200 | |||
5 | 3/1 | Team | 100 | |||
6 | 3/5 | Team | 100 | |||
7 | 3/6 | Team | 100 |
<tbody>
</tbody>