I have a spreadsheet with several different years of data in one row (last
year, this year, original plan).

I can create a table to subtotal by different criteria, but I'd like to add
a subtotal based on the text in another row.

Example: Sales at Cost are in column E. The year (TY, LY) is in column D.

Is it possible to subtotal only visible cells in column E when column D="TY"?