Subtotal Between Dates for Current Month

Hi

Looking for a function to give subtotal for current month

My table will have entries for the whole year & only need to see current months totals

See example

Thanks

Hi russkris and others

Thanks for answering

Yes - This gets me the current month's total but does not give me subtotal if I filter more.

I'm looking for a subtotal type of function between dates

1st to end of the month is only the first filter

I may filter more such as per week.

Thanks

russkris

Yes - I did state this forgetting to add the filter options or requests.

However, I did state my table will show entries for the whole year.


I also have other categories (not show) to filter such as type of expense entry.

← Want subotal for current month - 1st of the month to end of the month
Needs to also filter or give subtotal when additional filters are selected

Example - Want to filter for current week - Feb. 12th to Feb. 18th

I'm looking for a subtotal type of function between dates

One way:

Please enter these dates in C3 and D3 and try

Formula:

Please Login or Register  to view this content.

Fluff13

=SUM(FILTER(D9:D200,(C9:C200>=C3)*(C9:C200<=D3)*(MAP(C9:C200,LAMBDA(m,SUBTOTAL(103,m))))))


Works great!

What do these mean?

MAP
LAMBDA

Thanks everyone for assisting

or, another variation on a theme:

=SUM(FILTER(D9:D200,(C9:C200>=C3)*(C9:C200<=D3)*(MAP(C9:C200,LAMBDA(m,AGGREGATE(3,7,m))))))

This also Try

Formula:

Please Login or Register  to view this content.

Hi Everyone

Thanks for the great feedback and options!