Sumif Problem

[PatMorris]

Hello,

I am trying to create a ifsum formula where there is a unique value on two separate sheets (sheet1 & Sheet2). I am looking to sum an additional column that has dollar values connected to the unique value. Please note the possibly for duplicates of the unique value could occur </SPAN>

 

[PatMorris]

Still part of your data wil be useful.
In which Sheet does your CUSIP ID column is?
Whic Excel version are you using?

In sheet1 the Cusip ID is in row G1:G200 no duplicates of Cusip ID in sheet1. The dates go from January to September- across rows N to V. On sheet2, the Cusip ID is in row K- this sheet has duplicate Cusip ID's, the months are in row A and shows up for each Cusip ID, the dollar value I'm trying to sum for Each Cusip Id. By month is in row E.