ExcelBanter - Subtotal by Year, Large Spreadsheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Subtotal by Year, Large Spreadsheet? (https://www.excelbanter.com/excel-programming/329396-re-subtotal-year-large-spreadsheet.html)

Tom Ogilvy

Subtotal by Year, Large Spreadsheet?

Use a pivot table.

--
Regards,
Tom Ogilvy

"Al Franz" wrote in message
...
Have a long spreadsheet list of rows with Date (mm/dd/yyyy) in column A.
Would like to get subtotals by year. Using the FILTER does not work since
I
can not select a YEAR. Do I need to break column A into 2 columns, one
for
mm/dd, the other for yyyy? Or is there an easier way?

All times are GMT +1. The time now is 10:50 PM.