Jagwarman
asked on
sumif or something else
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
Client Name
PayCCy
GBP
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
=SUMPRODUCT(ClientName,A2, ProfitCcy, B2,GBP)
Please help.
jk.xlsx
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
Client Name
PayCCy
GBP
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
=SUMPRODUCT(ClientName,A2,
Please help.
jk.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER