Help with error Incorrect Argument Set

mbarthkelly

I'm trying to use this formula

=SUMIFS(CHILDREN([Reimbursement Amount]:[Reimbursement Amount]), [Reimbursement Date]:[Reimbursement Date], >DATE(2024, 1, 1), [Reimbursement Date]:[Reimbursement Date], <=DATE(2024, 12, 31))

But I keep getting the end message, incorrect argument set. I'm using this as a summary sheet formula. Any ideas?

Paul Newcome

What exactly are you wanting the formula to do?

mbarthkelly

I want to add the total reimbursements by year paid. These amounts are listed in child rows in the reimbursement amount column.

Once I have this information, I will use a report to list the payments made each year in a portal

Paul Newcome

Is there anything in the parent rows?

mbarthkelly

The parent rows contain totals from the child rows.

Paul Newcome

Ok. What you will need is a helper column (checkbox) with this:

=IF(COUNT(CHILDREN()) = 0, 1)

Then your SUMIFS would look like this:

=SUMIFS([Reimbursement Amount]:[Reimbursement Amount], [Reimbursement Date]:[Reimbursement Date], IFERROR(YEAR(@cell), 0) = 2024, [Helper Column]:[Helper Column], @cell = 1)