Forum Discussion
Formula to Sum by Currency and then covert by each FX Rate
Hi guys, I would like to build a formula that summarize a table by each currency and convert the total of each by a Fx Rate table then shows the results. Sample File: https://1drv.ms/x/s!Arc7etWKE...
=SUMPRODUCT(($E$5:$E$10=$E$14)*F$5:F$10*$F$14+($E$5:$E$10=$E$15)*F$5:F$10/$F$15+($E$5:$E$10=$E$16)*F$5:F$10/$F$16)Maybe with this formula in cell F20 and filled across range F20:G20.
Hi OliverScheurich ,
That is a good approach however if the fx table has 10 or maybe 30 currencies listed the size of this formula will be huge to admin.
Thanks!