• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

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
0
Jagwarman
Asked:
Jagwarman
1 Solution
 
johnb25Commented:
Hi,

Put this in D2: =SUMIFS(GBPEQUIV,Name,A2,CCY,B2)

John
0
 
JagwarmanAuthor Commented:
johnb25, thanks, that has been driving me crazy.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now