Add date criteria to SUMIFS

[rythmic_flow]

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!

 

[bbotzong]

Try this...

=SUMIFS('Sheet2'!$I:$I,'Sheet2'!$U:$U,">=30",'Sheet2'!$C:$C,'Report'!$A5,'Sheet2'!$I:$I,'Report'!$A$2)

 

[rythmic_flow]

Sorry, i forgot to mention that the criteria column in the table range (sheet 2) would be in cells 'Sheet2'!$X:$X.

I tried the following formula and i get a blank result:

=SUMIFS('Sheet2'!$I:$I,'Sheet2'!$U:$U,">=30",'Sheet2'!$C:$C,Report!$A5,'Sheet2'!$X:$X,Report!A2)

 

[rythmic_flow]

I've managed to get this working now. Bbot, your formula was correct, i just had some formatting issues that were preventing it.

Thanks!