Results 1 to 4 of 4

Trying to sum up values based on 2 conditions

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2012
    Location
    Santiago de Chile
    MS-Off Ver
    Excel 2007
    Posts
    36

    Trying to sum up values based on 2 conditions

    Hi Community,
    I am desperatly looking for a formula which can help me. In the Excel sheet attached to this post there is information about executive compensation included. The important stuff are the YEARS, the column labelled CASH COMPENSATION and the column labelled CUSIP. My problem is that i have several executives being compensated during one year according to one company (see CUSIP code). I need however the total Cash compensation during one year according to one CUSIP (company). In the end i would like to have an excel file with just one Compensation value, one CUSIP value and one value for Year, so basically the sum of compensation according to CUSIP and YEAR.

    It would be great if the formula would work for several years and several companies (CUSIPS) as i have more than 100 companies over 5 years.
    I hope i stated my problem as clear as possible and somebody is willing to help me on that. Thank you very much in advance.

    Paul
    Attached Files Attached Files
    Last edited by slacknoise; 03-29-2012 at 06:47 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1