When I filter on Column A - Project ID I want a subtotal of the dates in Column D - Start Date based on a date range

Question

When I filter on Column A - "Project ID" I want a subtotal of the dates in Column D - "Start Date" based on the date range in D1 & D2

Answer 1

Use a SUBTOTAL formula that refers to the filtered Start Date range and your date limits in D1 and D2.

Assume:

• Column A = Project ID (filtered with AutoFilter)
• Column D = Start Date (data starts in row 3)
• D1 = Start of date range
• D2 = End of date range

1. Turn the range into a proper list and apply filters (Data → Filter) on Project ID.
2. In any empty cell, enter a formula like:

=SUBTOTAL(9, FILTER(D3:D100, (D3:D100>=D1)*(D3:D100<=D2)))

Explanation based on context:

• SUBTOTAL(9, …) uses function number 9 = SUM on the visible (filtered) cells only.
• The inner range D3:D100 is the Start Date column.
• The FILTER condition (D3:D100>=D1)*(D3:D100<=D2) restricts the dates to the range in D1–D2.
• When Project ID in column A is filtered, only visible rows are considered by SUBTOTAL.

If FILTER is not available, first insert subtotals by Project ID (Data → Subtotal) and then use SUBTOTAL directly on the Start Date column, adjusting the date range manually or via helper columns.

---

References:

• Insert subtotals in a list of data in a worksheet
• SUBTOTAL function