Trying to sum up values based on 2 conditions

**slacknoise** · 03-29-2012, 06:42 AM

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

**Cutter** · 03-29-2012, 08:09 AM

If I understand you correctly:

Try the SUMIFS() function - with the year you want in G1 & the CUSIP in H1 use:
=SUMIFS(E:E,A:A,G1,B:B,H1)

Here's a link to read about the function: http://www.excelfunctions.net/Excel-...-Function.html

**slacknoise** · 03-29-2012, 08:23 AM

I dont really now why you included "G1" and "H1". Anyway i replaced "G1" with "A1" and consequently "H1" with "B1" and it works fine now. Thank you very much for the fast reply it works perfectly now. kind regards

**Cutter** · 03-29-2012, 08:29 AM

I used G1 and H1 as "holders" so the formula would be flexible for use in what I assume is a much larger file. That way you could change the input values in those 2 cells to get the totals from your data for various inputs in those 2 cells.
Anyway, glad it works for you. Please mark your thread as SOLVED.