Question: how to calculate the weighted average exchange rate?
Answer: The weighted average is now calculated as SUMPRODUCT(range with Dollar amounts, range with Export rates)/sum of Dollar amounts.