I'm stumped on another formula. I receive an "incorrect argument set"
Total [Dave Delivered] if the month is January
=SUMIF([Actual Date Completed]3:[Actual Date Completed]46, MONTH(@cell) = 1, [Dave Delivered]3:[Dave Delivered]40)
Thank you
Your ranges need to match in size and shape. It looks like one is rows 3 - 46 and the other is rows 3 - 40.
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.