Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Does it help if you change $A$3 to "<="&$A$3
Excel Formula Sum If using Year
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
We have a massive Fixed Asset tracking system for our Facility (Hospital) we have projects that have crossed fiscal years and in our current formula, it is not capturing the prior year Invoices that are in out "WIP" bucket, which is throwing my GL balance off. I am trying to get a formula that does a sum if and pulls anything 2022 and prior as the year - Current formula from cell N8 below.
- "Cost" is tab with GL data dump
- "YTD" is the current tab with summary
- I need the M:M data that = WIP, with A:A anything 2022 and prior (we can ignore the PY WIP)
=SUMIFS(Cost!$M:$M,Cost!$B:$B,YTD!$B8,Cost!$N:$N,"WIP",Cost!$A:$A,$A$3)+SUMIFS(Cost!$M:$M,Cost!$B:$B,YTD!$B8,Cost!$N:$N,"PY WIP",Cost!$A:$A,$A$3)
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author