R rjfields New Member Aug 1, 2012 #1 Hello, I have a 3 column table. I need to sum the values in col3 as long as the values in col1 are not duplicates (col2 has a status value that makes a col1 duplicate a unique record, i.e. a compound key). Col1 is sorted ascending. Thank you very much rob
Hello, I have a 3 column table. I need to sum the values in col3 as long as the values in col1 are not duplicates (col2 has a status value that makes a col1 duplicate a unique record, i.e. a compound key). Col1 is sorted ascending. Thank you very much rob
Hui Excel Ninja Staff member Aug 1, 2012 #2 Rob Firstly, Welcome to the Chandoo.org forums. Try: Code: =Sumproduct((Col2=Value)*(Col3)) If that doesn't help can you post a sample file, refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
Rob Firstly, Welcome to the Chandoo.org forums. Try: Code: =Sumproduct((Col2=Value)*(Col3)) If that doesn't help can you post a sample file, refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
