Help needed for SUMIF, Date Range

Hello

I am having trouble with the below formula to return date based on a date range and getting a return of #invalid operation. I checked this out in the community but not able to find a resolution.

=SUMIFS({All PM PO Tracker-Assigned To}, "Project Manager", {All PM PO Tracker- Change Order-Submitted}, "Invoiced", {Telaid- All PM PO -Sent to Invoice Date} >= DATE(2023, 1, 1))

Appreciate the help in advance

Find more posts tagged with

Formulas

Accepted answers

All comments

Kaveri Vipat

Hi @ Andrew Taglauer

I have seen your problem statement, it seems you want to return dates but applied the SUMIFS formula here to provide you with the solution, can you please share images of the sheet where you are trying to apply the formula?

It will be beneficial to understand it in a better way.

Thank you

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.