Subtotal and Countif

Originally Posted by Tony Valko

I didn't download your file.

Sounds like you want something like this:

=SUMPRODUCT(SUBTOTAL(3,OFFSET('Training Records'!G6,ROW('Training Records'!G6:G173)-ROW('Training Records'!G6),0)),--('Training Records'!G6:G173<$K$1))

Tonky Valko you are a star! That works perfectly! Thank you very much.