How can I use a formula to extract the total amount of a call/distribution based on PortfolioID by referencing the data on Image 2. So for instance there would be a running activity list of all the calls/distributions for the year(this example is just showing February activity. So I would want the formulas in columns F&G in image 1 to pull information pertaining to the month of February and sum all calls/distributions related to the Portfolio ID. Ideally I think a SUMIF statement would work best but any help would be appreciated. Thanks!
Image 1:
Image 2:
Image 1:
Image 2: