sumif or something else

Posted on 2014-07-11
Last Modified: 2014-07-11
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

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


Please help.
Question by:Jagwarman
    LVL 6

    Accepted Solution


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


    Author Comment

    johnb25, thanks, that has been driving me crazy.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now