Using COUNTIF(S) or SUMIF(S)-functions with SUBTOTAL-function

Hey! I keep a record of the training of athletes in Excel. The same view has a table for attendance and event data and an athlete-specific summary where I use the COUNTIF and SUMIF functions Fo...