Summing children rows without double counting parents
I am creating a spreadsheet to help track project financials for a specific grant that the non-profit which I work for received.
Specifically in the Summary Table, I have a sumifs formula which grabs specific line items based on the date and which installment of the grant they are using. I believe that the error is being caused by the fact that it is trying to double sum the parent and the children rows.
Formula in [Date]3 (which is dragged down and across for the rest of the years and installments):
=SUMIFS($[Amount (USD)]$20:$[Amount (USD)]$158, $[Hidden: Year]$20:$[Hidden: Year]$158, YEAR(@cell) = YEAR($[Hidden: Year]3), $[Hidden: Installment]$20:$[Hidden: Installment]$158, =Date$1)
If anyone sees any clarity it this, I would be super appreciative.