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