rythmic_flow
New Member
- Joined
- Jan 16, 2019
- Messages
- 17
I want to add a date criteria to the existing SUMIFS formula:
=SUMIFS('Sheet2'!$I:$I,'Sheet2'!$U:$U,">=30",'Sheet2'!$C:$C,Report!$A5)
There will be one cell in the sheet named "Report" that is set at End of previous month each month e.g. cell Report!A2. I would also like to add a critera that the SUM data of column I in sheet 2 also must equal to the date in =Report!A2
I don't want to build in the date itself into the formula, as the cell =Report!A2 will be manually updated each month.
As you can see, i already have built multiple criteria into the SUMIFS formula, however, when i try to build out the formula in the similar way, i just get a blank result.
Would appreciate any help here!
=SUMIFS('Sheet2'!$I:$I,'Sheet2'!$U:$U,">=30",'Sheet2'!$C:$C,Report!$A5)
There will be one cell in the sheet named "Report" that is set at End of previous month each month e.g. cell Report!A2. I would also like to add a critera that the SUM data of column I in sheet 2 also must equal to the date in =Report!A2
I don't want to build in the date itself into the formula, as the cell =Report!A2 will be manually updated each month.
As you can see, i already have built multiple criteria into the SUMIFS formula, however, when i try to build out the formula in the similar way, i just get a blank result.
Would appreciate any help here!