helpmeexcelgods
New Member
- Joined
- Sep 29, 2021
- Messages
- 2
- Office Version
- 2019
- 2016
- 2010
- Platform
- Windows
Hi all,
I am trying to calculate the amount per qty (column F). Problem is that some countries have both import and export, while some only have one way (either import or export); hence when I drag down the formula in cell F2, the formula in cell F4 automatically includes the amount for the next country.
May I know if there is any formula for me to calculate the amount per qty for each country, without having to edit each entry manually?
I am trying to calculate the amount per qty (column F). Problem is that some countries have both import and export, while some only have one way (either import or export); hence when I drag down the formula in cell F2, the formula in cell F4 automatically includes the amount for the next country.
May I know if there is any formula for me to calculate the amount per qty for each country, without having to edit each entry manually?
A | B | C | D | E | F | |
1 | Country | Type | Amount ($) | Qty | Amount Per Qty | |
2 | Argentina | Import | 5 | 3 | =(D2+D3)/E2 | |
3 | Export | 10 | #DIV/0! | |||
4 | Mexico | Import | 3 | 5 | =(D4+D5)/E4 | |
5 | Ireland | Import | 5 | 6 | | |
6 | Export | 6 | | | ||
7 | Indonesia | Import | 7 | 5 | | |
8 | Export | 4 | |