Count if with Subtotal in a table

Question

I need to get a percentage of times a value shows up in a filtered table. I have tried what is suggested on others questions but none of them are working. I have this formula but need it to exclude filtered rows and the count if option isn't there for subtotals =COUNTIF([Status],"On-Time")/COUNTA([Status]). Sample table (this would be filtered to show a certain vendor): I am looking for the answer 50% in this scenario.

Vendor	Promise Date	Received Date	Status
ABC Co.	7/1/15	6/25/15	On-Time
ABC Co.	7/1/15	7/5/15	Late
			FORMULA HERE

Answer 1

Hi, you have to use sumproduct see the link below which have and explanation on how formula works

http://chandoo.org/wp/2012/06/07/formula-forensics-023/

Answer 2

Thank you!

Answer 3

Hi,

Enter this formula

=SUMPRODUCT(SUBTOTAL(103,OFFSET(D1,ROW(D2:D4)-ROW(D1),))*(D2:D4="On-Time"))/SUMPRODUCT(1*(SUBTOTAL(103,OFFSET(D1,ROW(D2:D4)-ROW(D1),))))

Hope this helps.