SUMIFS - Multiple criteria and dates

[d0288]

I have a SUMIFS formula that already uses a few different criteria. I also wanted to add a criteria that it must = the date in one of the columns in the table range must match the date in one specific cell on another sheet.

I used the following formula, but i only get a blank result:

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


Sheet2 is the table range
Sheet2'!$U:$U is the SUM range
The result is going into a cell in worksheet named Report!

The date criteria i am attempting is the last part of the above formula. For the date criteria, there is a date column in 'Sheet2'!$X:$X and I only want the SUM of 'Sheet2'!$I:$I if the date in 'Sheet2'!$X:$X matches the date in cell Report!A2.

Any help much appreciated!

[rorya]

If the formula cell is on the Report sheet, you don't need (or generally want) the Report references in the formula:

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

but otherwise the formula seems to do what you describe. If you get 0 as a result, nothing matches the criteria so check them carefully (eg make sure the date in A2 doesn't have a hidden time part)

[d0288]

Rorya, perfect that works now. As you suggested, it was the formatting of the dates.

Thank you!

[rorya]

Glad to help. For future reference, I suggest you read the forum rules (here and elsewhere) on cross-posting, and make sure to follow them.