Here is the formula i started with. It gives me a #unparceable response
=SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row), Date:Date, YEAR(@cell) = YEAR(TODAY()))
Ive included a screen shot
You just have too many parenthesis tucked away. Give this a try...
=SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row, Date:Date, YEAR(@cell) = YEAR(TODAY())
ah. perfect. thanks! Works perfect.
Excellent! Happy to help! 👍️
Please don't forget to mark the most appropriate comment as the "Accepted Answer" so that others know a solution has been found.
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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.