Hello,
I need to find a formula that will return a sum value (£) - it must look in Column A for a specific code that is on another worksheet e.g. IT300-100, sum any costs against that code (may be multiple lines of costs) between a specific date range e.g. Jan 2022 <31/01/2021 to >01/02/2022.
My first part of the code would usually be =SUMIFS('Forecast Spend'!,A6:A1000,A19,'Forecast Spend!',N6:N1000)
The date range would be another formula = =SUMIFS('Forecast Spend'!N6:N1035,'Forecast Spend'!C6:C1035,">31/12/2021",'Forecast Spend'!C6:C1035,"<01/02/2022")
But how can I combine the two?
Many thanks
Bookmarks