So far I've been able to find an answer to any question I had on this forum, but as of today I needed to register in order to continue working on my Excel file.

I consider myself as being quite a rookie in Excel so please don't be too harsh on this newbie

I have the following problem: I am creating a turnover report with customers on the rows, in column D the currency of this specific customer (either USD or EUR), and in column E the turnover (drawn from a pivot table).

With the subtotal offset function I managed to create a totals row which accumulates the filtered results, but I want to add a function (like a SUMIFS) to multiply USD numbers ONLY by a fixed conversion rate.

To illustrate what I currently have, please see the screenshot below.

I hope the example and my intentions are clear.

Thanks a lot in advance!

Daniël