I am trying to find the Sum per client, by currency but so far have failed miserably.
I have attached a file sample which I hope will help.
I have a Tab called RawData and a Tab Called Monthly.
In RawData I have named ranges
on the Monthly tab I have Client Name, Client_Profit_Currency and Volumes
So, I want to find the Volumes Total of the Client/Ccy/GBP from the RawData Tab.
I have tried Sumproduct but it's not working