SUMIF or IndexMatch?

[excelhelper23]

Hi all,

A pretty simple question but I am stumped.
Say I have "Room Revenue" for 30 days in the month of October.

Room Revenue | 30,000 |1st Oct

Room Revenue | 30,000| 2nd Oct

Room Revenue | 29,000 | 1st Oct

Is there any way I can get the final value to sum up all Room Revenue for 1st Oct to display in a single cell?

 

[firstWeMeet]

=SUMIFS(B:B,A:A,"Room Revenue",C:C,"10/1/2017")

 

[excelhelper23]

=SUMIFS(B:B,A:A,"Room Revenue",C:C,"10/1/2017")

Thank you very much! It works now!