Help needed for SUMIF, Date Range

Andrew Taglauer

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

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