SUMIFS with date and category referencing another sheet

Hi - I have a cashflow chart that I want to pull expenses into by category and month. The expenses are located on another sheet with a dropdown list that is the same on the cashflow chart. I have tried this formula but it is not returning the results - just $0.00

=SUMIFS({Expenses Amount}, {Expenses Category}, Description@row , {Expenses Date Range}, AND(IFERROR(MONTH(@cell ), 0) = 2))

Find more posts tagged with

Formulas

SumIfs

Accepted answers

MGTRIX

I figured it out - used the date range instead and it worked great.

All comments

MGTRIX

I figured it out - used the date range instead and it worked great.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.