This may have to be done using SUMPRODUCT, but I'm trying to subtotal a table where range L7:L6000 in the total hours and column P is the Pay type.

Can you use the subtotal function that way when I filter in excel, it would sum the total hours in column L only if the corresponding cell in column P equals ST.