How do you sum the total of a specific product

[James bolton]

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

 

[Nebu]

Hi:

This is possible with sumif or sumproduct functions. However, I cannot give any specific solution without seeing the layout of your spreadsheets.

Thanks