How to sum total for a specific date in google spreadsheet?

Question

Google Sheets

Hi guys, can you please tell me how to sum a column with a specific date?
That is, so that the sum of numbers from column S for 01/24/2020 is displayed in a separate cell

Answer 1

If the dates do not contain time or the time at the beginning of the day, then
=SUMIF(T2:T13;"="&DATE(2020;1;25);S2:S13)

otherwise, you will have to round the dates

=ARRAYFORMULA(SUMIF(DATEVALUE(T2:T13);"="&DATE(2020;1;25);S2:S13))

You can do without ARRAYFORMULA SUMIFS

=SUMIFS(S2:S13;T2:T13;">="&DATE(2020;1;25);T2:T13;"<"&DATE(2020;1;26))

Answer 2

=sumif(S:S;"="&T4

Answer 3

=ArrayFormula(SUM(IF(DAYS(T:T;0)=DAYS("24.01.2020";0);S:S;0)))