How to count the number of values ​​and their sum?

Question

excel

There is a table in Google Sheets, replenished from the form. It is necessary to calculate the number of values: for today, for the current month, for each month, for the year. And so are the amounts.

Answer 1

For today (sum by D):

=СУММ(FILTER(D:D;A:A>=СЕГОДНЯ();A:A<(СЕГОДНЯ()+1)))

For today (number):

=счёт(FILTER(A:A;A:A>=СЕГОДНЯ();A:A<(СЕГОДНЯ()+1)))

The rest is by analogy. The only thing is that if you need for a calendar month, then the date must be formed using the DATE (year; month; day) function
Something like this:

=СУММ(
FILTER(D:D;A:A>=ДАТА(ГОД(СЕГОДНЯ());МЕСЯЦ(СЕГОДНЯ());1);A:A<ДАТА(ГОД(СЕГОДНЯ());1+МЕСЯЦ(СЕГОДНЯ());1)
)