James bolton
Member
Hi,
I have an excel problem I'd really like some help with.
On my sales worksheet I have a list of customers and their total sales (split between sales and fees) in 3 different currencies.
On the summary spreadsheet I need to know the total SALES for each customer (SALES only, not FEE's, fee's must be excluded) and ideally converted into USD using the fx rate. If its not possible to convert and SUM at the same time, then I don't mind if there are separate columns for the total EUR, USD, GBP and then have a converted total in a separate column.
Any help would be much appreciated, ideally no pivvot tables.
Thanks
JOBO
I have an excel problem I'd really like some help with.
On my sales worksheet I have a list of customers and their total sales (split between sales and fees) in 3 different currencies.
On the summary spreadsheet I need to know the total SALES for each customer (SALES only, not FEE's, fee's must be excluded) and ideally converted into USD using the fx rate. If its not possible to convert and SUM at the same time, then I don't mind if there are separate columns for the total EUR, USD, GBP and then have a converted total in a separate column.
Any help would be much appreciated, ideally no pivvot tables.
Thanks
JOBO
