Help with error Incorrect Argument Set

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?

Find more posts tagged with

Accepted answers

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.